请问各位老大,event 10704跟踪出来的trc文件,对象号怎么换算?

[复制链接]
查看11 | 回复0 | 2019-6-14 14:49:06 | 显示全部楼层 |阅读模式
请问各位老大,event 10704跟踪出来的trc文件,对象号怎么换算?
ORACLE_HOME = /u01/app/oracle/product/11.2.4/db_1
System name:
Linux
Node name:
vm01
Release:
3.10.0-514.el7.x86_64
Version:
#1 SMP Tue Nov 22 16:42:41 UTC 2016
Machine:
x86_64
Instance name: ora11g
Redo thread mounted by this instance: 1
Oracle process number: 19
Unix process pid: 1823, image: oracle@vm01 (TNS V1-V3)

*** 2021-11-14 23:17:44.357
*** SESSION ID

191.5) 2021-11-14 23:17:44.357
*** CLIENT ID

) 2021-11-14 23:17:44.357
*** SERVICE NAME

SYS$USERS) 2021-11-14 23:17:44.357
*** MODULE NAME

SQL*Plus) 2021-11-14 23:17:44.357
*** ACTION NAME

) 2021-11-14 23:17:44.357
ksqgtl *** CU-eae336a8-00000000 mode=6 flags=0x10000 timeout=300 ***<----------eae336a8-00000000 是可以转换成对象号么?怎么看出是在哪个对象上请求了mode=6的锁?
ksqgtl: xcb=0xf13b1cf8, ktcdix=2147483647, topxcb=0xf13b1cf8

ktcipt(topxcb)=0x0
*** 2021-11-14 23:17:44.357
ksucti: init txn DID from session DID
ksqgtl:

ksqlkdid: 0001-0013-0000000E
*** 2021-11-14 23:17:44.357
*** ksudidTrace: ksqgtl

ktcmydid(): 0001-0013-0000000E

ksusesdi: 0001-0013-0000000F

ksusetxn: 0001-0013-0000000E
ksqgtl: RETURNS 0
*** 2021-11-14 23:17:44.358
ksqrcl: CU,eae336a8,0
ksqrcl: returns 0
*** 2021-11-14 23:17:44.358
ksqgtl *** TM-00015bda-00000000 mode=4 flags=0x401 timeout=0 ***<---------是在00015bda-00000000上请求了mode=4的锁么?
ksqgtl: xcb=0xf13b1cf8, ktcdix=2147483647, topxcb=0xf13b1cf8

ktcipt(topxcb)=0x0
*** 2021-11-14 23:17:44.358
ksucti: init session DID from txn DID:
ksqgtl:

ksqlkdid: 0001-0013-0000000E
*** 2021-11-14 23:17:44.358
*** ksudidTrace: ksqgtl

ktcmydid(): 0001-0013-0000000E

ksusesdi: 0001-0013-0000000F

ksusetxn: 0001-0013-0000000E
ksqgtl: RETURNS 0
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行