增大SGA

最新推荐文章于 2021-05-15 14:32:27 发布

congjuyan5037

最新推荐文章于 2021-05-15 14:32:27 发布

阅读量140

点赞数

文章标签：数据库

SQL> alter system set sga_max_size=7000m scope=spfile;

System altered.

SQL> show parameter target

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target                   integer     0
db_flashback_retention_target        integer     1440
fast_start_io_target                 integer     0
fast_start_mttr_target               integer     0
memory_max_target                    big integer 0
memory_target                        big integer 0
parallel_servers_target              integer     96
pga_aggregate_target                 big integer 4820M
sga_target                           big integer 1536M
SQL> alter system set sga_target=5000m scope=spfile;

System altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 7349010432 bytes
Fixed Size                  2214336 bytes
Variable Size            3019900480 bytes
Database Buffers         4294967296 bytes
Redo Buffers               31928320 bytes
Database mounted.
Database opened.
SQL> show parameter target

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
lock_sga                             boolean     FALSE
pre_page_sga                         boolean     FALSE
sga_max_size                         big integer 7040M
sga_target                           big integer 5056M
SQL> show sga

Total System Global Area 7349010432 bytes
Fixed Size                  2214336 bytes
Variable Size            3087009344 bytes
Database Buffers         4227858432 bytes
Redo Buffers               31928320 bytes

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26870952/viewspace-1253850/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26870952/viewspace-1253850/