Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How do I obtain an AWR report for a certain time period?

April 26, 2017awr certain obtain period report time

0

Posted

How do I obtain an AWR report for a certain time period?

1 Answer

0

Posted

First, you need to identify the AWR snapshots that cover your target time period. This can easily be done by going to the Enterprise Manager AWR Snapshots page. Command line users can query the DBA_HIST_SNAPSHOT view to identify the best set of AWR snapshots. An AWR report, for the pair of snapshots, can then be obtained using Enterprise Manager “View Report” feature or by executing the SQL*Plus AWRRPT.SQL script which can be found in the $ORACLE_HOME/rdbms/admin directory.