Hi,
Our Oracle system is suffering from very poor performance, and Ive noticed that there is are relatively high enqueue timeouts (has reached over 500 before) but no enqueue waits, which is confusing me.
Can anyone shed any light on this problem and suggest anything else I should check to help me solve this, as it would be very much appreciated !!
22 enqueue timeouts 4 154
23 enqueue waits 4 0
24 enqueue deadlocks 4 0
25 enqueue requests 4 2760828
26 enqueue conversions 4 1480
27 enqueue releases 4 2760557
EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT
latch free 3390 2989 0 0
pmon timer 21190 21167 0 0
rdbms ipc message 2700823 62400 0 0
log buffer space 1648 52 0 0
log file switch completion 14 4 0 0
log file sync 2205 11 0 0
smon timer 217 211 0 0
resmgr:wait in actses run 433 21 0 0
resmgr:waiting in check2 58617 74 0 0
PX qref latch 604 580 0 0
PX Idle Wait 214712 214175 0 0
PX Deq Credit: send blkd 1209217 4936 0 0
PX Deq: Signal ACK 360 137 0 0
PX Deq: Execute Reply 7258 1898 0 0
PX Deq: Execution Msg 43023 34370 0 0
PX Deq: Table Q Normal 3569359 4365 0 0
Cheers
John (Sudmill)
Our Oracle system is suffering from very poor performance, and Ive noticed that there is are relatively high enqueue timeouts (has reached over 500 before) but no enqueue waits, which is confusing me.
Can anyone shed any light on this problem and suggest anything else I should check to help me solve this, as it would be very much appreciated !!
22 enqueue timeouts 4 154
23 enqueue waits 4 0
24 enqueue deadlocks 4 0
25 enqueue requests 4 2760828
26 enqueue conversions 4 1480
27 enqueue releases 4 2760557
EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT
latch free 3390 2989 0 0
pmon timer 21190 21167 0 0
rdbms ipc message 2700823 62400 0 0
log buffer space 1648 52 0 0
log file switch completion 14 4 0 0
log file sync 2205 11 0 0
smon timer 217 211 0 0
resmgr:wait in actses run 433 21 0 0
resmgr:waiting in check2 58617 74 0 0
PX qref latch 604 580 0 0
PX Idle Wait 214712 214175 0 0
PX Deq Credit: send blkd 1209217 4936 0 0
PX Deq: Signal ACK 360 137 0 0
PX Deq: Execute Reply 7258 1898 0 0
PX Deq: Execution Msg 43023 34370 0 0
PX Deq: Table Q Normal 3569359 4365 0 0
Cheers
John (Sudmill)
