Generating AWR Reports in EM
AWR can produce a summary report on statistics stored in the workload repository. The report contains general information about the overall behavior of the system over a time period defined by two snapshots.
To generate an AWR report, navigate to the Automatic Workload Repository page in Database Control on the Server tab page. On this page, click the link corresponding to the number of snapshots. This opens the Snapshots page. On the Snapshots page, select the beginning snapshot, select View Report from the Actions drop-down list, and click Go. On the View Report page, select the ending snapshot and click OK.
Generating AWR Reports in SQL*Plus
The AWR report has the same information, whether it is generated from SQL*Plus or from EM.The awrrpt.sql SQL*Plus script run in the ORACLE_HOME/rdbms/admin directory produces the report. The user running the script must have the SELECT_CATALOG_ROLE privilege. The script prompts for the following report options:
• HTML or text report
• The number of days of snapshots to choose from.
Entering the number of days shows you the most recent snapshots being taken. You can also determine which SNAP_IDs you should use by querying the DBA_HIST_SNAPSHOT table to retrieve the mapping between
a SNAP_ID and the wall-clock time.
• Begin SNAP_ID, end SNAP_ID: A snapshot pair that defines the reporting time period
• File name: The user-specified file into which the report is written
The report contains the same information whether it is produced as a text or as an HTML report.However, HTML reports can be viewed in a Web browser, and the advantage of an HTML report is the presence of links to the detail sections of the report.
AWR can produce a summary report on statistics stored in the workload repository. The report contains general information about the overall behavior of the system over a time period defined by two snapshots.
To generate an AWR report, navigate to the Automatic Workload Repository page in Database Control on the Server tab page. On this page, click the link corresponding to the number of snapshots. This opens the Snapshots page. On the Snapshots page, select the beginning snapshot, select View Report from the Actions drop-down list, and click Go. On the View Report page, select the ending snapshot and click OK.
Generating AWR Reports in SQL*Plus
The AWR report has the same information, whether it is generated from SQL*Plus or from EM.The awrrpt.sql SQL*Plus script run in the ORACLE_HOME/rdbms/admin directory produces the report. The user running the script must have the SELECT_CATALOG_ROLE privilege. The script prompts for the following report options:
• HTML or text report
• The number of days of snapshots to choose from.
Entering the number of days shows you the most recent snapshots being taken. You can also determine which SNAP_IDs you should use by querying the DBA_HIST_SNAPSHOT table to retrieve the mapping between
a SNAP_ID and the wall-clock time.
• Begin SNAP_ID, end SNAP_ID: A snapshot pair that defines the reporting time period
• File name: The user-specified file into which the report is written
The report contains the same information whether it is produced as a text or as an HTML report.However, HTML reports can be viewed in a Web browser, and the advantage of an HTML report is the presence of links to the detail sections of the report.
No comments:
Post a Comment