eygle.com - 留言簿 - 回复留言

eygle.com - 留言簿 - 回复留言 - Powered by eYgLe.Com

返回留言簿

回复留言

留言ID:

留言原文:

To:
　　你好，eagle，请教一个问题：
oracle 9i中为何不能动态调整db_cache_size
SQL> show sga;
Total System Global Area 76616884 bytes
Fixed Size 451764 bytes
Variable Size58720256 bytes
Database Buffers 16777216 bytes
Redo Buffers 667648 bytes

SQL> show parameter sga_max
NAMETYPEVALUE

sga_max_sizebig integer76616884
SQL> show parameter pool_size
NAMETYPEVALUE

java_pool_size big integer0
large_pool_size big integer8388608
shared_pool_size big integer33554432

db_cache_size <= sga_max_size-java_pool_size-large_pool_size-shared_pool_size-Redo Buffers-Fixed Size
= 76616884 - 0 - 8388608 - 33554432 - 451764 - 667648
=33554432
现在要执行
SQL> alter system set db_cache_size=20971520;
alter system set db_cache_size=20971520
*
ERROR 位于第 1 行:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00384: Insufficient memory to grow cache
为何啊为何！！！db_cache_size新值仍然在允许的范围内啊

From: vicki
2008.06.19 01:04