oracle event --- 10704

Oracle事件10704可以帮助我们了解队列Enqueue的使用情况。

SQL> ho 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

*** 2013-11-18 13:44:52.637
ksqgtl *** CU-c6f2c950-00000000 mode=6 flags=0x10000 timeout=300 ***
ksqgtl: no transaction
ksqgtl: use existing ksusetxn DID
ksqgtl:
	ksqlkdid: 0001-001C-000001CF

*** 2013-11-18 13:44:52.637
*** ksudidTrace: ksqgtl
	ksusesdi:   0000-0000-00000000
	ksusetxn:   0001-001C-000001CF
ksqgtl: RETURNS 0      --获取锁

*** 2013-11-18 13:44:52.639
ksqrcl: CU,c6f2c950,0
ksqrcl: returns 0     --释放锁

*** 2013-11-18 13:44:52.639
ksqgtl *** TM-00015363-00000000 mode=3 flags=0x401 timeout=21474836 ***
ksqgtl: xcb=0xd98672c8, ktcdix=2147483647, topxcb=0xd98672c8
	ktcipt(topxcb)=0x0

*** 2013-11-18 13:44:52.640
ksucti: init txn DID from session DID 
ksqgtl:
	ksqlkdid: 0001-001C-000001CF

*** 2013-11-18 13:44:52.640
*** ksudidTrace: ksqgtl
	ktcmydid(): 0001-001C-000001CF
	ksusesdi:   0000-0000-00000000
	ksusetxn:   0001-001C-000001CF
ksqgtl: RETURNS 0

*** 2013-11-18 13:44:52.640
ksqgtl *** TX-000a0011-0000378e mode=6 flags=0x10021 timeout=21474836 ***
ksqgtl: xcb=0xd98672c8, ktcdix=2147483647, topxcb=0xd98672c8
	ktcipt(topxcb)=0x0

*** 2013-11-18 13:44:52.640
ksucti: init session DID from txn DID: 
ksqgtl:
	ksqlkdid: 0001-001C-000001CF

*** 2013-11-18 13:44:52.640
*** ksudidTrace: ksqgtl
	ktcmydid(): 0001-001C-000001CF
	ksusesdi:   0000-0000-00000000
	ksusetxn:   0001-001C-000001CF

*** 2013-11-18 13:44:52.640
ksqcmi: TX,a0011,378e mode=6 timeout=21474836    --获取tx锁时，被阻塞，一直等待在这里

*** 2013-11-18 13:44:57.552
ksqcmi: returns 0                               --阻塞消除
ksqgtl: RETURNS 0

*** 2013-11-18 13:44:57.552
ksqgtl *** TX-000a000b-00003794 mode=6 flags=0x401 timeout=0 ***   --获取tx锁
ksqgtl: xcb=0xd98672c8, ktcdix=2147483647, topxcb=0xd98672c8
	ktcipt(topxcb)=0x0

*** 2013-11-18 13:44:57.552
ksucti: init session DID from txn DID: 
ksqgtl:
	ksqlkdid: 0001-001C-000001CF

*** 2013-11-18 13:44:57.552
*** ksudidTrace: ksqgtl
	ktcmydid(): 0001-001C-000001CF
	ksusesdi:   0000-0000-00000000
	ksusetxn:   0001-001C-000001CF
ksqgtl: RETURNS 0

*** 2013-11-18 13:44:57.553
ksqrcl: TX,a0011,378e
ksqrcl: returns 0

*** 2013-11-18 13:45:01.496
ksqrcl: TX,a000b,3794
ksqrcl: returns 0

*** 2013-11-18 13:45:01.496
ksqrcl: TM,15363,0
ksqrcl: returns 0