select * from(SELECT /*+LEADING(x h) USE_NL(h)*/h.sql_id, SUM(10) ash_secsFROM dba_hist_snapshot x, dba_hist_active_sess_history hWHERE x.begin_interval_time > sysdate -1AND h.SNAP_id = X.SNAP_idAND h.dbid = x.dbidAND h.instance_number = x.instance_numberAND h.event in ('db file sequential read','db file scattered read')GROUP BY h.sql_idORDER BY ash_secs desc )where rownum < 10;
No comments:
Post a Comment