DBTIME and ELAPSED_TIME Percentage Information From All AWR Reports

6 Nov by dbtut

DBTIME and ELAPSED_TIME Percentage Information From All AWR Reports

The Oracle Database produces reports that are called AWR at specific periods and that share the general status of the database. You can use the following script to examine the related AWRs in more detail.

 

This script was tested in 11gR1 and 11gR2. Please test the scripts on your test servers before running them in the production environment.

Leave a Reply

Your email address will not be published. Required fields are marked *