如何查得 latch: cache buffers chains address 执块争用所属的OBJ
来源:互联网 发布:静态数据采集仪 编辑:程序博客网 时间:2024/05/28 05:14
查询过程
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
- 如何查得 latch: cache buffers chains address 执块争用所属的OBJ
- latch: cache buffers chains
- latch: cache buffers chains
- latch: cache buffers chains
- latch: cache buffers chains
- latch: cache buffers chains
- cache buffers chains latch
- latch: cache buffers chains
- latch:cache buffers chains的优化思路
- 缓解latch: cache buffers chains的案例
- Cache buffers chains latch 与Cache buffers LRU chain latch
- 低效的SQL引发的cache buffers chains latch
- latch: cache buffers chains-热块的简单模拟实验
- latch: cache buffers chains引起的响应慢
- 一个cache buffers chains latch需要管理的块
- latch: cache buffers chains导致CPU冲高的问题
- 关于latch: cache buffers chains的sql优化
- Cache Buffers Chains and Latch Spelunking
- 二叉树(二)
- Java.Web - MD5 Java 实现代码
- JAVA 异常体系
- ubuntu 10.04安装sun-java5-jdk(转载)
- Java.Web - Cookies 随笔
- 如何查得 latch: cache buffers chains address 执块争用所属的OBJ
- ora-00257 archiver error
- 禁止分录排序
- 网络常见攻击方法分类
- 有序数组的组合问题
- [linux] Linux的/proc目录
- 使用binder
- 关于SQLSERVER 事物的运用(3)嵌套事物以及嵌套存储过程的异常的处理
- Android锁屏状态下弹出activity