Upgrade 10g/11g : MEMORY_TARGET ?
I have to upgrade production database from 10.2.0.3 to 11.2.0.3.
What values to attribute to MEMORY_TARGET for Automatic Memory Management (AMM) with 40Go of RAM ?
Best regards.
GD.
****************
production 10g
****************
SQL> select * from v$sga_target_advice ;
SGA_SIZE SGA_SIZE_FACTOR ESTD_DB_TIME ESTD_DB_TIME_FACTOR ESTD_PHYSICAL_READS
---------- --------------- ------------ ------------------- -------------------
10240 1 138548 1 88501160
12800 1,25 128837 0,9299 85297418
20480 2 118517 0,8553 79270489
17920 1,75 121414 0,8763 80969711
15360 1,5 124585 0,8992 82819386
SQL> select * from v$pga_target_advice ;
PGA_TARGET_FOR_ESTIMATE PGA_TARGET_FACTOR ADVICE_STATUS BYTES_PROCESSED ESTD_EXTRA_BYTES_RW ESTD_PGA_CACHE_HIT_PERCENTAGE ESTD_OVERALLOC_COUNT
----------------------- ----------------- ------------- --------------- ------------------- ----------------------------- --------------------
134217728 0,125 ON 637407462400 13709625344 98 135
268435456 0,25 ON 637407462400 3589620736 99 2
536870912 0,5 ON 637407462400 2026287104 100 0
805306368 0,75 ON 637407462400 2026287104 100 0
1073741824 1 ON 637407462400 1914828800 100 0
1288489984 1,2 ON 637407462400 1503379456 100 0