设置MEMORY_TARGET会导致RESULT_CACHE_MAX_SIZE在重启后归零

Oracle11g中,如果设置了MEMORY_TARGET,则RESULT_CACHE_MAX_SIZE的设置在数据库重启后自动被置为0


问题再现:

SQL> alter system set memory_target = 220m scope = spfile;

System altered.

SQL> alter system set result_cache_max_size = 10m scope = spfile;

System altered.

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

Total System Global Area 209235968 bytes
Fixed Size 1298920 bytes
Variable Size 192941592 bytes
Database Buffers 12582912 bytes
Redo Buffers 2412544 bytes
Database mounted.
Database opened.
SQL> show parameter memory_target

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
memory_target big integer 220M
SQL> show parameter result_cache_max_size

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
result_cache_max_size big integer 0
SQL> alter system set result_cache_max_size = 10m scope = both;

System altered.

SQL> show parameter result_cache_max_size

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
result_cache_max_size big integer 0
SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 -
Production PL/SQL Release 11.1.0.6.0 - Production
CORE 11.1.0.6.0 Production
TNS for Linux: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production

如果不设置MEMORY_TARGET而使用SGA_TARGETPGA_AGGREGATE_TARGET,则不会导致RESULT_CACHE_MAX_SIZE被置为0值:

SQL> alter system reset memory_target scope = spfile sid = '*';

System altered.

SQL> alter system reset memory_max_target scope = spfile sid = '*';

System altered.

SQL> alter system set sga_target = 170m scope = spfile;

System altered.

SQL> alter system set pga_aggregate_target = 50m scope = spfile;

System altered.

SQL> alter system set result_cache_max_size = 10m scope = spfile;

System altered.

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

Total System Global Area 209235968 bytes
Fixed Size 1298920 bytes
Variable Size 150998552 bytes
Database Buffers 54525952 bytes
Redo Buffers 2412544 bytes
Database mounted.
Database opened.
SQL> show parameter result_cache_max_size

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
result_cache_max_size big integer 10M
SQL> alter system set result_cache_max_size = 20m;

System altered.

SQL> show parameter result_cache_max_size

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
result_cache_max_size big integer 20M

不使用MEMORY_TARGET方式设置内存参数,则RESULT_CACHE_MAX_SIZE参数设置正常。

这个bugmetalink上还没有详细的描述。

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

转载于:http://blog.itpub.net/4227/viewspace-69459/

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值