Which SQL spending most time doing I/Os in the past 5 minutes
                                                 Last update (2009-04-03 17:04:04)
                                                                                                                   Date added (2008-02-20 18:42:51)

Which SQL spending most time doing I/Os in the past 5 minutes
SELECT ash.sql_id, COUNT(*) 
FROM v$active_session_history ash, v$event_name evt 
WHERE ash.sample_time > SYSDATE - 5/24/60
AND ash.session_state = 'WAITING' 
AND ash.event_id = evt.event_id 
AND evt.wait_class = 'User I/O' 
GROUP BY sql_id ORDER BY COUNT(*) DESC;
Reviews
Categories
Filters
Search