← Performance
Oracle · Performance
How to check top Oracle wait classes since instance startup
Rank Oracle wait classes by cumulative time waited from V$SYSTEM_WAIT_CLASS to see where the instance is spending time.
Tested on11g12c18c19c21c23ai26ai
Cheapest possible wait profile: sum time_waited per wait class since instance startup, average by number of waits. Whatever dominates here is where the instance has been spending time, and where tuning effort pays off most.
SELECT wait_class,
SUM(time_waited) AS time_waited,
SUM(time_waited) / SUM(total_waits) AS avg_wait
FROM v$system_wait_class
GROUP BY wait_class
ORDER BY 3 DESC;performancewaitsv$system_wait_class