WHERE wait_time = 0
AND event NOT IN
('smon timer','pmon timer','rdbms ipc message', 'SQL*Net message from client')
GROUP BY event ORDER BY 1 DESC
;
Sample Output:
Code: Select all
COUNT(*) EVENT
---------- ----------------------------------------------------------------
1 jobq slave wait
1 Streams AQ: qmn coordinator idle wait
1 Streams AQ: waiting for time management or cleanup tasks
1 Streams AQ: qmn slave idle wait