采样某瞬时SAMPLE_TIME或者某时间段内SAMPLE_TIME的某SQL_ID、某等待事件的current_obj#分组

采样某瞬时SAMPLE_TIME或者某时间段内SAMPLE_TIME的某SQL_ID、某等待事件的current_obj#分组

采样某瞬时sample_time

select x.CURRENT_OBJ#, count(*)

  from v$active_session_history x

 where sql_id = '&sql_id'

   and event = '&event_name'

   and sample_id=&sample_id

 group by x.CURRENT_OBJ#;

采样某时间段内

select x.CURRENT_OBJ#, count(*)

  from v$active_session_history x

 where sql_id = '&sql_id'

   and event = '&event_name'

   and sample_time between

               to_date('&date1', 'yyyy-mm-dd hh24:mi:ss') and

               to_date('&date2', 'yyyy-mm-dd hh24:mi:ss')

 group by x.CURRENT_OBJ#;