SQL> show parameter memory
NAME TYPE
VALUE
------------------------------------ -------------------------------- ------------------------------
hi_shared_memory_address integer
0
memory_max_target big integer
0
memory_target big integer
0
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
4G
sga_target big integer
4G
SQL> show parameter pga
NAME TYPE
VALUE
------------------------------------ -------------------------------- ------------------------------
pga_aggregate_target big integer
2G
SQL>
MEMORY_MAX_TARGET
默认值=0
MEMORY_MAX_TARGET 指定了DBA可以设置MEMORY_TARGET参数的最大值
MEMORY_TARGET
默认是为0 SGA自动调整被关闭