摘要:
转摘:http://www.cnblogs.com/preftest/archive/2010/11/14/1876856.html1、监控等待事件select event,sum(decode(wait_time,0,0,1)) prev, sum(decode(wait_time,0,1,0)) curr,count(*)from v$session_wait group by event order by 4;Lock wait occur when a session attempts to acquire a lock that is already held by another 阅读全文
posted @ 2012-08-27 16:48 徐正柱- 阅读(13051) 评论(2) 推荐(1) 编辑