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