AWR Time Model Statistics Script

Time model statistics is an important part in AWR Report. It provides the details of processing time spent by database for the given snapshot periods. Script time_model.sql gives the Time Model Statistics detail for any two snapshots.

What is DB Time?

What is DB Time? DB Time is the total time spent by the all user processes which are actively working or actively waiting in the database calls. It includes the CPU Time, IO Wait time and non-idle time. It tells

AWR DBTime script

DB Time is very important metric in AWR report. When analyzing an AWR report the, DB Time is the first thing which i see as it tells us how much activity database was performing in that time interval. Suppose we have to perform analysis on