awr及ash和addm 来源视图之一dba_hist_active_sess_history

最新推荐文章于 2024-07-16 13:08:31 发布

翁特锋

最新推荐文章于 2024-07-16 13:08:31 发布

阅读量1.9k

点赞数

分类专栏： Oracle Scripts

本文链接：https://blog.csdn.net/wengtf/article/details/8771110

版权

Oracle Scripts 专栏收录该内容

14 篇文章 0 订阅

订阅专栏

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';