Database Tuning (MOSC)

MOSC Banner

undo section of AWR report looking weird

edited Jun 15, 2012 5:06AM in Database Tuning (MOSC) 3 commentsAnswered
I ran AWR on the database that is a replication of the production server. This replication server hosts all the materialized views that is created through database link through production. All materialized views refresh at different times.

The undo section of the AWR report is looking very weird. Not sure if I need to increase the undo size.

 Snap Id      Snap Time      Sessions Curs/Sess
            --------- ------------------- -------- ---------
Begin Snap:     33918 12-Jun-12 09:00:56        24       1.3
  End Snap:     33919 12-Jun-12 10:00:57        23       2.6
   Elapsed:               60.02 (mins)
   DB Time:               32.79 (mins)

Cache Sizes
~~~~~~~~~~~                       Begin        End
                             ---------- ----------
               Buffer Cache:        80M        80M  Std Block Size:         8K
           Shared Pool Size:       192M       192M      Log Buffer:     2,112K

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