Database Tuning (MOSC)

MOSC Banner

Very High DB TIme

edited Jan 22, 2012 4:58PM in Database Tuning (MOSC) 8 commentsAnswered
We have 3 DBs on same server,  and the DB version is 10.2.0.4.0. When I compare the AWR reports I see huge difference in DB time in one DB as compared to other 2 DBs. Please see the 2nd DB below where it has exceeded even the elapsed time.

DB Name         DB Id    Instance     Inst Num Release     RAC Host
------------ ----------- ------------ -------- ----------- --- ------------
PUBBART       3537585976 PUBBART             1 10.2.0.4.0  NO  bupscubdb2

              Snap Id      Snap Time      Sessions Curs/Sess
            --------- ------------------- -------- ---------
Begin Snap:     24781 04-Jan-12 05:00:47        90       2.7
  End Snap:     24791 04-Jan-12 10:00:45        91       2.9
   Elapsed:              299.96 (mins)
   DB Time:                9.01 (mins) <<<<<<<

DB Name         DB Id    Instance     Inst Num Release     RAC Host
------------ ----------- ------------ -------- ----------- --- ------------

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