Database Tuning (MOSC)

MOSC Banner

tuning

edited Jun 30, 2011 10:22PM in Database Tuning (MOSC) 3 commentsAnswered
 Please suggest on below data for the improvement of database performance. Also suggest how to read this data and how we should approach for db tuning based on below output.

MAJOR    MINOR         WAIT_EVENT                                      SECONDS    PCT
-------- ------------- ---------------------------------------- -------------- ------
CPU time parsing       n/a                                               27788   .00%
         reloads       n/a                                                5499   .00%
         execution     n/a                                            25839758   .00%

disk I/O normal I/O    db file sequential read                     67001073999  8.95%
         full scans    db file scattered read                      82626892427 11.04%
         direct I/O    direct path read                            31828454341  4.25%
                       direct path read temp                        2519375619   .34%
                       direct path write temp                         63988123   .01%
                       direct path write                               3420061   .00%
                       direct path sync                                1577328   .00%

MAJOR    MINOR         WAIT_EVENT                                      SECONDS    PCT
-------- ------------- ---------------------------------------- -------------- ------
disk I/O other I/O     control file sequential read                 1703936850   .23%

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