AWR – Wait Classes by Total Wait Time

In AWR, the ‘Wait Classes by Total Wait Time’ table comes under the ‘Report Summary’ section. Refer to the below figure: To analyse this section, firstly check for the ‘Wait Class’ column. If User I/O, System I/O and Others have moderate ‘Waits’ value then it is fine. But if ‘Concurrency’ under the wait class has … Read more

AWR – Instance Efficiency Percentages

AWR Instance Efficiency Percentages

In AWR, the ‘Instance Efficiency Percentages’ table comes under the ‘Report Summary’ section. Refer to the below figure: The following metrics are available in the ‘Instance Efficiency Percentages’ table of an AWR report: Buffer Nowait % (Buffer Nowait Ratio) This metric provides the percentage of availability of the data buffers. This ratio gives an idea … Read more

AWR – Load Profile

In AWR, the Load Profile table comes under the ‘Report Summary’ section. Refer to the below figure: The following metrics are available in the Load Profile table of an AWR report: DB Time(s) DB Time(s) is the number of average active sessions during the given period. The active sessions are calculated by dividing the ‘DB … Read more