Most active SQL in the past 5 minutes
                                                 Last update (2008-02-20 19:09:29)
                                                                                                                   Date added (2008-02-20 18:41:55)

Most active SQL in the past 5 minutes
select sql_id, count(*), 
100 * round(count(*) / sum(count(*)) over (), 3) pctload 
from v$active_session_history
where sample_time > sysdate - 5/24/60 
 and session_type <> 'BACKGROUND' 
  group by sql_id 
    order by count(*) desc;
Reviews
Categories
Filters
Search