oracle 10g常见问题精选(4)

中华网科技 http://tech.china.com 2005-06-29 11:42:43

【进入BBS】【进入聊天室】【 推荐给朋友 】【浏览字号：大 中 小】【关闭窗口】

　　
　　可以看出, db_cache_size的值已经被自动调小了.

　　再把java pool 的值改回去
SQL> alter system set java_pool_size=8M;
SQL> select name, block_size, current_size,prev_size from v$buffer_pool;

name block_size current_size prev_size
-----------------------------------------------------------------------------------
KEEP 8192 188 204

SQL> select name, block_size, current_size,prev_size from v$buffer_pool;

pool M bytes
-------------------------------------------------
java pool 20
large pool 4
shared pool 84
189.002403

　　这一次, db_cache_size的值没有变化 , JAVA_POOL_SIZE的值也没有变化

　　修改large pool的值为16M
SQL> alter system set large_pool_size=16M;
System altered.

SQL> select name,block_size,current_size,prev_size from v$buffer_pool;

NAME BLOCK_SIZE CURRENT_SIZE PREV_SIZE
-------------------- ---------- ------------ ---------
DEFAULT 8192 176 188

SQL> Select pool, sum(bytes)/1024/1024 as "M bytes" from v$sgastat group by pool;

POOL M bytes
------------ ----------
java pool 20
large pool 16
shared pool 84
177.002403

首页 上页 | ...1| 2 | 3 | 4 | 5 | 下页 尾页  共 5 页