oracle 11g 启用自动内存管理时sga_max 这个参数设置的意义不大

最新推荐文章于 2024-03-12 19:30:34 发布

cool1899

最新推荐文章于 2024-03-12 19:30:34 发布

阅读量703

点赞数

文章标签：数据库内存管理

Note:

The preceding steps instruct you to set SGA_TARGET and PGA_AGGREGATE_TARGET to zero so that the sizes of the SGA and instance PGA are tuned up and down as required, without restrictions. You can omit the statements that set these parameter values to zero and leave either or both of the values as positive numbers. In this case, the values act as minimum values for the sizes of the SGA or instance PGA.

[oracle@ora11g ~]$ sqlplus  / as sysdba;

SQL*Plus: Release 11.2.0.4.0 Production on Wed Nov 5 18:01:25 2014

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

SYS@ sms> show parameter mem;

NAME                               TYPE       VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address          integer    0
memory_max_target                   big integer 2608M
memory_target                      big integer 2608M
shared_memory_address             integer    0
SYS@ sms> show parameter sga;

NAME                               TYPE       VALUE
------------------------------------ ----------- ------------------------------
lock_sga                            boolean    FALSE
pre_page_sga                      boolean    FALSE
sga_max_size                      big integer 2G
sga_target                         big integer 1G
SYS@ sms> show parameter pga;

NAME                               TYPE       VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_target                big integer 600M

[oracle@ora11g ~]$ sqlplus  / as sysdba;

SQL*Plus: Release 11.2.0.4.0 Production on Wed Nov 5 18:01:25 2014

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

SYS@ sms> show parameter mem;

NAME                               TYPE       VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address          integer    0
memory_max_target                   big integer 2608M
memory_target                      big integer 2608M
shared_memory_address             integer    0
SYS@ sms> show parameter sga;

NAME                               TYPE       VALUE
------------------------------------ ----------- ------------------------------
lock_sga                            boolean    FALSE
pre_page_sga                      boolean    FALSE
sga_max_size                      big integer 2G
sga_target                         big integer 1G
SYS@ sms> show parameter pga;

NAME                               TYPE       VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_target                big integer 600M

　　　　在oracle 11g 中，启用了自动内存管理（memory_target，memory_max_target　为非０的值）， sga_max_sizep 这个参数应是限制sga最大可分配的内存。这个参数设的再大，（等于memory_max_target的值），而实际分配的内大大小应是　<=(memory_max_target－pga_aggregate_target )，所以设置的意义不大，或直接设置 sga_max_sizep＝memory_max_target
      不知我的理解对不对？

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

转载于:http://blog.itpub.net/27036311/viewspace-1321874/