Database Tuning (MOSC)

MOSC Banner

RDBMS 11.2.0.3

edited Jan 15, 2014 10:39PM in Database Tuning (MOSC) 7 commentsAnswered
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
-------------- ----------- ------------

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center