We have a requirement to provide the database memory utlizations on the oracle 10gr2 and 11gr2 databases.
1) I thought to provide the SGA and PGA allocation sizes from sga_max_size and pga_aggregate_target but this will give
the memory allocations not the utlizations, May i know which query or view will provide the Average database memory utilization per hour and per day basis.
2) on other it was confused me, In 11gr2 (11.2.0.1 - AIX 5.3 (64bit)) database both the memory_max_target,memory_target and
sga_max_size, sga_target, pga_aggregate_target parameters and are enabled, so here databases uses memory_max_target or Sga_max_size parameters
Values are allocated as below.
NAME VALUE
-------------------------- ------
pga_aggregate_target 1G
sga_max_size 1G
sga_target 1G
memory_max_target 2G
memory_target 2G