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自动调整被关闭