sga tuning
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
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
0