oracle调整内存大小

1、查看已分配内存，看到memory_max_target为26G
SQL> show parameter sga

NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
lock_sga                 boolean     FALSE
pre_page_sga                 boolean     TRUE
sga_max_size                 big integer 20G
sga_target                 big integer 0
unified_audit_sga_queue_size         integer     1048576
SQL> show parameter target

NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target             integer     0
db_big_table_cache_percent_target    string     0
db_flashback_retention_target         integer     1440
fast_start_io_target             integer     0
fast_start_mttr_target             integer     0
memory_max_target             big integer 26G
memory_target                 big integer 26G
parallel_servers_target          integer     128
pga_aggregate_target             big integer 0
sga_target                 big integer 0

2、修改memory_max_target为26G后需重启数据库，注意要小于物理内存的3/4否则oracle无法启动，以下是修改步凑：
[oracle@fuhanghang ~]$ sqlplus / as sysdba
SQL> alter system set memory_max_target=26214M scope=spfile;
SQL> alter system set memory_target=26214M scope=spfile;
SQL> alter system set sga_max_size=20214M scope=spfile;
SQL> alter system set sga_target=20214M scope=spfile;
SQL> alter system set pga_aggregate_target=6000M scope=spfile;
SQL> shutdown immediate;
SQL> startup;
————————————————
版权声明：本文为CSDN博主「顺其自然~」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。
原文链接：https://blog.csdn.net/fuhanghang/article/details/90775422