Database Tuning (MOSC)

MOSC Banner

sga tuning

edited Jun 27, 2011 2:03AM in Database Tuning (MOSC) 4 commentsAnswered ✓
 Based on the values below am I correct in assuming that the sweet spot is having an sga size of 45056 which gives the lowest dbtime?
SQL> select * from v$sga_target_advice;

  SGA_SIZE SGA_SIZE_FACTOR ESTD_DB_TIME ESTD_DB_TIME_FACTOR ESTD_PHYSICAL_READS
---------- --------------- ------------ ------------------- -------------------
     22528               1        39276                   1            65529967
      5632             .25        47304              1.2044            67954576
     11264              .5        40918              1.0418            66027995
     45056               2        35537               .9048            64402852
     28160            1.25        38844                .989            65398907
     33792             1.5        38710               .9856            65359589
     39424            1.75        38471               .9795            65287506
     16896             .75        40046              1.0196            65759322


Thank you
Ed

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