select sql_text
from dba_hist_sqltext
where sql_id in
(select sql_id
from dba_hist_sqlstat
where snap_id between &Start_SnapID and &End_SnapID
and elapsed_time_total > 7200000000 -- number for 1 hour
)
/
where sql_id in
(select sql_id
from dba_hist_sqlstat
where snap_id between &Start_SnapID and &End_SnapID
and elapsed_time_total > 7200000000 -- number for 1 hour
)
/
No comments:
Post a Comment