272 Oracle Database 11g DBA Handbook
You can see the AWR data via OEM or via the data dictionary views listed earlier in this
section. Additional views supporting AWR include V$ACTIVE_SESSION_HISTORY (sampled
every second), DBA_HIST_SQL_PLAN (execution plans), and DBA_HIST_WR_CONTROL (for
the AWR settings).
Generating AWR Reports
You can generate reports from AWR either via OEM or via the reporting scripts provided. The
awrrpt.sql script generates a report based on the differences in statistics between the beginning
and ending snapshots. A second report, awrrpti.sql, displays a report based on the beginning and
ending snapshots for a specified database and instance.
Both awrrpt.sql and awrrpti.sql are located in the $ORACLE_HOME/rdbms/admin directory.
When you execute a report (from any DBA account), you will be prompted for the type of report
(HTML or text), the number of days for which snapshots will be listed, the beginning and ending
snapshot IDs, and the name for the output file.
Running the Automatic Database Diagnostic Monitor Reports
Rather than relying on manual reporting against the AWR table (much as you did with STATSPACK
in previous versions of Oracle), you can use the Automatic Database Diagnostic Monitor (ADDM).
Because it is based on AWR data, ADDM requires that the STATISTICS_LEVEL parameter be set
(either to TYPICAL or ALL, as recommended earlier). You can access ADDM via the Performance
Analysis section of OEM, or you can run an ADDM report manually.
Pages:
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465