row cache lock

最新推荐文章于 2024-01-09 11:38:24 发布

scan724

最新推荐文章于 2024-01-09 11:38:24 发布

阅读量747

点赞数

分类专栏： OWI

本文链接：https://blog.csdn.net/zhaoyangjian724/article/details/23826903

版权

OWI 专栏收录该内容

87 篇文章 34 订阅 ¥39.90 ¥99.00

订阅专栏

SQL> col name format a30
SQL> select * from (select SAMPLE_TIME,
       SESSION_ID,  
       NAME,  
       P1,  
       P2,  
       P3,
       ash.BLOCKING_SESSION  
  from v$active_session_history ash, v$event_name enm  
 where ash.event# = enm.event#
 and enm.NAME='row cache lock')
 where rownum<10;  2    3    4    5    6    7    8    9   10   11  

SAMPLE_TIME								    SESSION_ID NAME				      P1	 P2	    P3 

BLOCKING_SESSION
--------------------------------------------------------------------------- ---------- ------------------------------ ---------- ---------- ---------- -----

-----------
15-APR-14 07.48.08.840 PM							    22 row cache lock			      13	  0	     5
15-APR-14 07.45.49.883 PM							  1159 row cache lock

了解本专栏