Monday , May 29 2023

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.


About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

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