eagle’s home

在一次troubleshooting中使用到了这个trace event,感觉还是蛮好用的，和大家分享一下。

10704 event用于trace enqueue的获取过程。
$oerr ora 10704
10704, 00000, “Print out information about what enqueues are being obtained”
// *Cause: When enabled, prints out arguments to calls to ksqcmi and
// ksqlrl and the return values.
// *Action: Level indicates details:
// Level: 1-4: print out basic info for ksqlrl, ksqcmi
// 5-9: also print out stuff in callbacks: ksqlac, ksqlop
// 10+: also print out time for each line

SQL> alter session set events ‘10704 trace name context forever, level 12′;

Session altered.

SQL> alter index test_idx rebuild online;

Index altered.

SQL> alter session set events ‘10704 trace name context off’;

Session altered.

到udump下察看trace文件如下:

Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production
ORACLE_HOME = /export/home/oracle/products/9205
System name: SunOS
Node name: qadb08
Release: 5.8
Version: Generic_108528-18
Machine: sun4u
Instance name: CSHAN
Redo thread mounted by this instance: 1
Oracle process number: 18
Unix process pid: 5613, image: oracle@qadb08 (TNS V1-V3)

*** SESSION ID:(17.5439) 2006-09-11 19:39:43.866
*** 2006-09-11 19:39:43.866
ksqcmi: TT,1,0 mode=4 timeout=21474836
ksqcmi: returns 0
*** 2006-09-11 19:39:43.900
ksqcmi: TM,1b79,0 mode=4 timeout=21474836
ksqcmi: returns 0
*** 2006-09-11 19:39:43.900
ksqcmi: TM,1b79,0 mode=2 timeout=21474836
ksqcmi: returns 0
*** 2006-09-11 19:39:43.905
ksqcmi: TM,1b79,0 mode=4 timeout=21474836
ksqcmi: returns 0
*** 2006-09-11 19:39:43.908
ksqcmi: TM,1c15,0 mode=6 timeout=0
ksqcmi: returns 0

其中的”1b79″,”1c15″是object_id的16进制号，可以转换成10进制察看相应的object_name

SQL> select to_number(’1b79′,’xxxxxxxxxxxx’) from dual;

TO_NUMBER(’1B79′,’XXXXXXXXXXXX’)
——————————–
7033

SQL> select to_number(’1c15′,’xxxxxxxxxxxx’) from dual;

TO_NUMBER(’1C15′,’XXXXXXXXXXXX’)
——————————–
7189

SQL> select object_name,object_type from user_objects where object_id in (7033,7189);

OBJECT_NAME OBJECT_TYPE
—————————— ——————
TEST TABLE

7189对应的是SYS_JOURNAL_ 的临时logging Table. Rebuild成功后被drop掉了。

Eagle Fan oracle events