|
TOP
|
|
记一次数据库无法增删改趋于HANG住状态的故障诊断和处理(五)
ing for 'library cache lock' [LOCK: handle=7ef56d78] wait
34: waiting for 'library cache lock' [LOCK: handle=7ef56f88] wait
35: waiting for 'library cache lock' [LOCK: handle=7ef56f88] wait
36: waiting for 'library cache lock' [LOCK: handle=7ef56d78] wait
37: last wait for 'ksdxexeotherwait'
Blockers
~~~~~~~~
Above is a list of all the processes. If they are waiting for a resource
then it will be given in square brackets. Below is a summary of the
waited upon resources, together with the holder of that resource.
Notes:
~~~~~
o A process id of '???' implies that the holder was not found in the
systemstate.
Resource Holder State
Enqueue CI-00000001-00000005 8: waiting for 'rdbms ipc reply'
Enqueue WF-00000000-00000000 22: 22: is waiting for 8:
Enqueue TX-0009001E-00000299 22: 22: is waiting for 8:
LOCK: handle=7ef56d78 28: waiting for 'log file switch (checkpoint incomplete)'
LOCK: handle=7ef56f88 30: waiting for 'buffer busy waits' (1,2ba2,1)
Object Names
~~~~~~~~~~~~
Enqueue CI-00000001-00000005
Enqueue WF-00000000-00000000
Enqueue TX-0009001E-00000299
LOCK: handle=7ef56d78 TABL:EXFSYS.RLM$SCHDNEGACTION
LOCK: handle=7ef56f88 TABL:EXFSYS.RLM$EVTCLEANUP
List of Processes That May Be Stuck
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
8: waiting for 'rdbms ipc reply' wait
11: waiting for 'log file switch (checkpoint incomplete)' wait
15: waiting for 'switch logfile command' wait
18: waiting for 'Streams AQ: qmn coordinator idle wait' wait
19: waiting for 'log file switch (checkpoint incomplete)' wait
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' wait
23: waiting for 'enq: WF - contention' wait
24: waiting for 'SQL*Net message from client' wait
25: waiting for 'buffer busy waits' (2,9,11) wait
26: waiting for 'enq: TX - row lock contention' wait
27: waiting for 'log file switch (checkpoint incomplete)' wait
28: waiting for 'log file switch (checkpoint incomplete)' wait
29: waiting for 'library cache lock' wait
30: waiting for 'buffer busy waits' (1,2ba2,1) wait
31: waiting for 'library cache lock' wait
32: waiting for 'library cache lock' wait
33: waiting for 'library cache lock' wait
34: waiting for 'library cache lock' wait
35: waiting for 'library cache lock' wait
36: waiting for 'library cache lock' wait |
SO: 0x83b5fd60, type: 4, owner: 0x83a69028, flag: INIT/-/-/0x00
(session) sid: 133 trans: 0x822d5790, creator: 0x83a69028, flag: (41) USR/- BSY/-/-/-/-/-
DID: 0001-001C-00000002, short-term DID: 0000-0000-00000000
txn branch: (nil)
oct: 0, prv: 0, sql: (nil), psql: (nil), user: 0/SYS
service name: SYS$USERS
O/S info: user: oracle, term: UNKNOWN,
ospid: 4790, machine: ora10g
program: oracle@ora10g (J001)
waiting for 'log file switch (checkpoint incomplete)' blocking sess=0x(nil) seq=1 wait_time=0 seconds since wait started=12130
=0, =0, =0
Dumping Session Wait History
for 'log file switch (
checkpoint incomplete)' count=1 wait_time=1107898
=0, =0, =0
for 'log file switch (
checkpoint incomplete)' count=1 wait_time=336 ...
PROCESS 8:
----------------------------------------
SO: 0x83a5f208, type: 2, owner: (nil), flag: INIT/-/-/0x00
(process)
Oracle pid=8, calls cur/top: 0x83ba9a28/0x83ba9a28, flag: (16) SYSTEM
int error: 0, call error: 0, sess error: 0, txn error 0
(post info) last post received: 0 0 33
last post received-location: ksrpublish
last process to post me: 83a68840 1 0
last post sent: 0 0 24
|