Database Tuning (MOSC)

MOSC Banner

Is the wait event in the AWR report enough to cause for concern?

edited Jun 12, 2012 10:05PM in Database Tuning (MOSC) 10 commentsAnswered
I ran the AWR report today and got the following stats. I am not sure if the I/O events should be cause for concern. I understand that lots of people say performance tuning is a reactive thing, but I just want to make sure the system runs ok and I do as much as I can proactively. Please advice. Thank you very much. Environment: version 11.2.0.2 on solaris 10

              Snap Id      Snap Time      Sessions Curs/Sess
            --------- ------------------- -------- ---------
Begin Snap:      9471 11-Jun-12 09:00:52       107       4.5
  End Snap:      9472 11-Jun-12 10:00:21       105       4.6
   Elapsed:               59.48 (mins)
   DB Time:               29.91 (mins)

Cache Sizes                       Begin        End
~~~~~~~~~~~                  ---------- ----------
               Buffer Cache:        96M        96M  Std Block Size:         8K

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