23: waiting for 'enq: WF - contention' [Enqueue WF-00000000-00000000] wait
Cmd: PL/SQL Execute
24: waiting for 'SQL*Net message from client' wait
25: waiting for 'buffer busy waits' (2,9,11) wait
Cmd: Select
26: waiting for 'enq: TX - row lock contention'[Enqueue TX-0009001E-00000299] wait
27: waiting for 'log file switch (checkpoint incomplete)' wait
Cmd: Insert
28: waiting for 'log file switch (checkpoint incomplete)' wait
29: waiting for 'library cache lock' [LOCK: handle=7ef56d78] wait
30: waiting for 'buffer busy waits' (1,2ba2,1) wait
31: waiting for 'library cache lock' [LOCK: handle=7ef56f88] wait
32: waiting for 'library cache lock' [LOCK: handle=7ef56d78] wait
33: waiting 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=7ef56f88 TABL:EXFSYS.RLM$EVTCLEANUP
System State 2
~~~~~~~~~~~~~~~~
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-00000005] wait
23: waiting for 'enq: WF - contention' [Enqueue WF-00000000-00000000] wait
Cmd: PL/SQL Execute
24: waiting for 'SQL*Net message from client' wait
25: waiting for 'buffer busy waits' (2,9,11) wait
Cmd: Select
26: waiting for 'enq: TX - row lock contention'[Enqueue TX-0009001E-00000299] wait
27: waiting for 'log file switch (checkpoint incomplete)' wait
Cmd: Insert
28: waiting for 'log file switch (checkpoint incomplete)' wait
29: waiting for 'library cache lock' [LOCK: handle=7ef56d78] wait
30: waiting for 'buffer busy waits' (1,2ba2,1) wait
31: waiting for 'library cache lock' [LOCK: handle=7ef56f88] wait
32: waiting for 'library cache lock' [LOCK: handle=7ef56d78] wait
33: wait