AWR in Memory Statistics
SQL Statistics – SQL statistics
Java time, wait-class time, bind variables, efficient top
SQL based on CPU, elapsed and parse statistics.
v$segment_statistics, v$sys_time_model, v$sysmetric_history,
The AWR collects performance data on resources and stored
tables. AWR takes snapshots of the system every 60 minutes
AWR does not contain enough information to perform current
analysis. Typically, the nature of current analysis requires
information on activity in the last five to ten minutes.
These tables are viewable through Oracle
Enterprise Manager or through the dba_hist views. The AWR
captures all important SGA metrics about the SGA in the
dba_hist_sga views and interfaces with the ADDM. SGA
advisory functions dynamically optimize the shared pool, data
buffer cache, Java pool, and PGA memory areas.
Figure 6.8 - SGA information in the
ASH and its influence on memory statistics
will be reviewed next.