<0/123/6/0x83a6d750/5378/No Wait>
Chain 4 : :
<0/126/2/0x83a6c780/4991/library cache lock>
-- <0/127/1/0x83a6bf98/4933/library cache lock>
-- <0/130/1/0x83a6a7e0/4875/library cache lock>
Chain 5 : :
<0/131/1/0x83a69ff8/4821/buffer busy waits>
-- <0/126/2/0x83a6c780/4991/library cache lock>
-- <0/127/1/0x83a6bf98/4933/library cache lock>
-- <0/130/1/0x83a6a7e0/4875/library cache lock>
Chain 6 : :
<0/136/7/0x83a68840/4770/log file switch (checkpoint inco>
Chain 7 : :
<0/139/10/0x83a67870/4609/buffer busy waits>
Chain 8 : :
<0/141/6/0x83a668a0/4748/enq: WF - contention>
Chain 9 : :
<0/147/3/0x83a658d0/3079/Streams AQ: qmn slave idle wait>
Chain 10 : :
<0/148/4/0x83a650e8/3077/Streams AQ: waiting for time man>
Chain 11 : :
<0/150/166/0x83a64900/4752/log file switch (checkpoint inco>
Chain 12 : :
<0/152/1/0x83a64118/3068/Streams AQ: qmn coordinator idle>
Chain 13 : :
<0/159/3/0x83a62960/3062/switch logfile command>
Chain 14 : :
<0/161/1/0x83a609c0/3054/log file switch (checkpoint inco>
Extra information that will be dumped at higher levels:
[level 4] : 2 node dumps -- [REMOTE_WT] [LEAF] [LEAF_NW]
[level 5] : 8 node dumps -- [SINGLE_NODE] [SINGLE_NODE_NW] [IGN_DMP]
[level 6] : 12 node dumps -- [NLEAF]
[level 10] : 12 node dumps -- [IGN]
State of nodes
([nodenum]/cnode/sid/sess_srno/session/ospid/state/start/finish/[adjlist]/predecessor):
[122]/0/123/6/0x83b52750/5378/SINGLE_NODE_NW/1/2//none
[124]/0/125/1/0x83b55220/4993/NLEAF/3/8/[128][132]/127
[125]/0/126/2/0x83b56788/4991/NLEAF/9/12/[130]/126
[126]/0/127/1/0x83b57cf0/4933/NLEAF/13/14/[125][130]/129
[127]/0/128/3/0x83b59258/4931/NLEAF/15/16/[128][124][132]/131
[128]/0/129/1/0x83b5a7c0/4877/NLEAF/4/7/[132]/124
[129]/0/130/1/0x83b5bd28/4875/NLEAF/17/18/[125][126][130]/none
[130]/0/131/1/0x83b5d290/4821/NLEAF/10/11/[132]/125
[131]/0/132/3/0x83b5e7f8/4815/NLEAF/19/20/[128][124][127][132]/none
[132]/0/133/2/0x83b5fd60/
4790/
LEAF/5/6//128 <<<<<< [135]/0/136/7/0x83b63d98/4770/SINGLE_NODE/21/22//none
[137]/0/138/137/0x83b66868/4757/NLEAF/23/28/[143]/none
[138]/0/139/10/0x83b67dd0/4609/NLEAF/29/30/[132]/none
[139]/0/140/8/0x83b69338/4605/IGN/31/32//none
[140]/0/141/6/0x83b6a8a0/4748/NLEAF/33/34/[143]/none
[143]/0/144/47/0x83b6e8d8/
4402/NLEAF/24/27/[163]/137
[146]/0/147/3/0x83b72910/3079/SINGLE_NODE/35/36//none
[147]/0/148/4/0x83b73e78/3077/SINGLE_NODE/37/38//none
[149]/0/150/166/0x83b76948/4752/SINGLE_NODE/39/40//none
[151]/0/152/1/0x83b79418/3068/SINGLE_NODE/41/42//none
[154]/0/155/1/0x83b7d450/3066/IGN/43/44//none
[155]/0/156/1/0x83b7e9b8/3064/IGN/45/46//none
[158]/0/159/3/0x83b829f0/3062/SINGLE_NODE/47/48//none
[159]/0/160/1/0x83b83f58/3056/IGN/49/50//none
[160]/0/161/1/0x83b854c0/3054/SINGLE_NODE/51/52//none
[161]/0/162/1/0x83b86a28/3052/IGN/53/54//none
[162]/0/163/1/0x83b87f90/3050/IGN/55/56//none
[163]/0/164/1/0x83b894f8/
3048/
LEAF/25/26//143 <<<<<< [165]/0/166/1/0x83b8bfc8/3044/IGN/59/60//none
[166]/0/167/1/0x83b8d530/3042/IGN/61/62//none
[167]/0/168/1/0x83b8ea98/3040/IGN/63/64//none
[168]/0/169/1/0x83b90000/3038/IGN/65/66//none
[169]/0/170/1/0x83b91568/3036/IGN/67/68//none
做了SYSTEMSTATE DUMP: 用ass对SYSTEMSTATE处理以后:
System State 1
~~~~~~~~~~~~~~~~
1:
2: waiting for 'pmon timer' wait
3: waiting for 'rdbms ipc message' wait
4: waiting for 'rdbms ipc message' wait
5: waiting for 'rdbms ipc message' wait
6: waiting for 'rdbms ipc message' wait
7: waiting for 'rdbms ipc message' wait
8: waiting for 'rdbms ipc reply' wait
9: waiting for 'rdbms ipc message' wait
10: waiting for 'rdbms ipc message' wait
11: waiting for 'log file switch (checkpoint incomplete)' wait
12: waiting for 'rdbms ipc message' wait
13:
14:
15: waiting for 'switch logfile command' wait
16: waiting for 'rdbms ipc message' wait
17: waiting for 'rdbms ipc message' wait
18: waiting for 'Streams AQ: qmn coordinator idle wait' wait
19: waiting for 'log file switch (checkpoint incomplete)' wait
Cmd: Insert
20: for 'Streams AQ: waiting for time management or cleanup tasks' wait
21: waiting for 'Streams AQ: qmn slave idle wait' wait
22: waiting for 'enq: CI - contention' [Enqueue CI-00000001-0000000 |
|