如何查得 latch: cache buffers chains address 执块争用所属的OBJ

最新推荐文章于 2013-11-16 15:04:06 发布

甲骨灰

最新推荐文章于 2013-11-16 15:04:06 发布

阅读量886

点赞数

分类专栏： ORACLE 文章标签： latch cache buffers

本文链接：https://blog.csdn.net/XmallWood/article/details/8912011

版权

ORACLE 专栏收录该内容

45 篇文章 0 订阅

订阅专栏

查询过程

v$session 查得p1RAW ---> x$bh HLADDR 查得OBJ -->DBA_OBJECTS

-------------------

select owner,object_name,subobject_name,object_id,object_type from dba_objects where object_id='738884';

SQL> select sql_id,event,p1text,p1,p1raw from v$session where sid ='1054';

SQL_ID EVENT P1TEXT P1 P1RAW
------------- ----------------------------------------------------- ----------- ---------------------------------------------------------------- ---------- ----------------
d14muz6j4t9kc latch: cache buffers chains address 1.38350581 C00000101EA875D0

---根据P1RAW 查到OBJ ID 排序 order by TCH desc

SQL> select OBJ from x$bh where HLaddr='C000000C222B2C70';

SQL> select OBJ,tch from x$bh where HLaddr='C000000C222B2C70' order by TCH desc;

       OBJ        TCH
---------- ----------
    738884        296
   5763425         43
   5705408         17
   5763241         13
   5592113          4
   5775169          3
   5592113          2
    690936          2
    543148          2
   1914891          1
   2402382          1
   5775114          1

12 rows selected

--查询TCH最高的OBJ 为分区表的某个分区

SQL> select owner,object_name,subobject_name,object_id,object_type from dba_objects where object_id='738884';

OWNER OBJECT_NAME SUBOBJECT_NAME OBJECT_ID OBJECT_TYPE
------------------------------ -------------------------------------------------------------------------------- ------------------------------ ---------- ---------------------------------------------------------
SGPM ARC_R_PLAN P200801 738884 TABLE PARTITION