请问各位老大,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 |