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