Ash的来源视图之一:dba_hist_active_sess_history
以下是查询rac 中出现 lc和 pin s wait on x 2个经典等待事件的例子:
select * from dba_hist_active_sess_history
where sample_time >= to_timestamp('2013-04-08 02:00:00', 'yyyy-mm-dd hh24:mi:ss')
and sample_time <= to_timestamp('2013-04-08 02:59:00', 'yyyy-mm-dd hh24:mi:ss')
and event='latch:library cache';
select * from dba_hist_active_sess_history
where sample_time >= to_timestamp('2013-04-08 02:00:00', 'yyyy-mm-dd hh24:mi:ss')
and sample_time <=to_timestamp('2013-04-08 02:59:00', 'yyyy-mm-dd hh24:mi:ss')
and event='cursor:pin S wait on X';