Oracle修改内存使用情况

[oracle@pamiddle ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue Dec 15 10:33:08 2015

Copyright (c) 1982, 2013, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

[color=blue]SQL>[/color] show parameter memory

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 1584M
memory_target big integer 1584M
shared_memory_address integer 0
[color=blue]SQL>[/color] show parameter sga

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 1584M
sga_target big integer 0
[color=blue]SQL>[/color] show parameter pga

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_target big integer 0
[color=blue]SQL>[/color] alter system set sga_max_size=512m scope=spfile;

System altered.

[color=blue]SQL>[/color] alter system set memory_target=512m scope=spfile;

System altered.

[color=blue]SQL>[/color] alter system set memory_max_target=1024m scope=spfile;

System altered.

[color=blue]SQL>[/color] shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
[color=blue]SQL>[/color] startup
ORACLE instance started.

Total System Global Area 534462464 bytes
Fixed Size 2254952 bytes
Variable Size 390072216 bytes
Database Buffers 134217728 bytes
Redo Buffers 7917568 bytes
Database mounted.
Database opened.

[color=blue]SQL>[/color] show parameter memory

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 1G
memory_target big integer 512M
shared_memory_address integer 0

[color=blue]SQL>[/color] show parameter sga

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 512M
sga_target big integer 0

[color=blue]SQL>[/color] show parameter pga

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_target big integer 0


【[color=red]注[/color]】: sga_max_size不能大于memory_target，不然数据库启动失败。