select sql_id from DBA_HIST_ACTIVE_SESS_HISTORY where session_id=1170 and snap_id=12738 and instance_number=1;

select snap_id from dba_hist_snapshot where END_INTERVAL_TIME> to_timestamp('2012-9-7 11:30:00','yyyy-mm-dd hh24:mi:ss')
and  END_INTERVAL_TIME< to_timestamp('2012-9-7 14:00:00','yyyy-mm-dd hh24:mi:ss')

select sql_text from dba_hist_sqltext where sql_id='bgh3by1jcm8bp';

select sql_id from DBA_HIST_ACTIVE_SESS_HISTORY where session_id=1170 and snap_id in (12738,12737)  and instance_number=1;

版权声明：本文为博主原创文章，未经博主允许不得转载。