RDBMS 11.2.0.3
Hi,
We are having severe performance issue in our EBS environment with 11GR2 database. I am trying to troubleshoot, and these are my initial findings. There are high number of waits
EVENT TOTAL_WAITS
---------------------------------------------------------------- -----------
TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT
-------------- ----------- ------------
Streams AQ: deallocate messages from Streams Pool 971199
0 1770 0
latch: cache buffers chains 1081910
0 35083 .03
control file sequential read 1509605
0 19788 .01
EVENT TOTAL_WAITS
---------------------------------------------------------------- -----------
TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT
-------------- ----------- ------------
direct path read 2727041
0 33219993 12.18
read by other session 3406946
0 50530604 14.83
PX Deq: Table Q Normal 6442963
0 18118695 2.81
EVENT TOTAL_WAITS
---------------------------------------------------------------- -----------
TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT
-------------- ----------- ------------
We are having severe performance issue in our EBS environment with 11GR2 database. I am trying to troubleshoot, and these are my initial findings. There are high number of waits
EVENT TOTAL_WAITS
---------------------------------------------------------------- -----------
TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT
-------------- ----------- ------------
Streams AQ: deallocate messages from Streams Pool 971199
0 1770 0
latch: cache buffers chains 1081910
0 35083 .03
control file sequential read 1509605
0 19788 .01
EVENT TOTAL_WAITS
---------------------------------------------------------------- -----------
TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT
-------------- ----------- ------------
direct path read 2727041
0 33219993 12.18
read by other session 3406946
0 50530604 14.83
PX Deq: Table Q Normal 6442963
0 18118695 2.81
EVENT TOTAL_WAITS
---------------------------------------------------------------- -----------
TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT
-------------- ----------- ------------
0