How to set sga_max_size in Oracle19C ?

Oct 28, 2022 9:12PM

We are moving our Oracle11g database to Oracle19C.

This is our SGA/MEMORY settings in Oracel11g.

sga_target=0

sga_max_size= 12884901888

memory_target= 25769803776

memory_max_target= 25769803776

It seems sga_max_size is only for 10g. sga_max_size should not be set from 11g.

My question is:

(1) Do I need to set sga_max_size in 11g if sga_target=0?

(2) If the answer is YES in (1), do I need to set memory_target=0 and memory_max_target=0?

(3) Can I still keep memory_target= 25769803776 and memory_max_target= 25769803776 if the answer in (2) is NO.

(4) In 19C, is it OK to keep these 4 parameters the same value as in 11g?

Database Install/Upgrade/Opatch (MOSC)