在oracle11g中,设置好了memory_target和memory_max_size后,sga_max_size这个参数还有用吗?下面是我当前数据库的内存参数情况:SQL> show parameter memory;
NAME TYPE VALUE
------------------------------------ ---------------------- --------------------
hi_shared_memory_address integer 0
memory_max_target big integer 16G
memory_target big integer 16G
shared_memory_address integer 0
SQL> show parameter sga;
NAME TYPE VALUE
------------------------------------ ---------------------- --------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 16G
sga_target big integer 0
SQL> show parameter pga;
NAME TYPE VALUE
------------------------------------ ---------------------- --------------------
pga_aggregate_target big integer 0