Oracle keep buffer的一些疑问

[fireme5535]

在我们的生产上使用了 keep buffer ，查看cache大小
SQL> show parameter cache;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
client_result_cache_lag big integer 3000
client_result_cache_size big integer 0
db_16k_cache_size big integer 0
db_2k_cache_size big integer 0
db_32k_cache_size big integer 0
db_4k_cache_size big integer 0
db_8k_cache_size big integer 0
db_cache_advice string ON
db_cache_size big integer 0
db_flash_cache_file string
db_flash_cache_size big integer 0
db_keep_cache_size big integer 40G
查看使用的keep buffer
select segment_name, bytes / 1024 / 1024
from dba_segments
where BUFFER_POOL = 'KEEP';
SEGMENT_NAME BYTES/1024/1024
1 T_1 8627
2 T_2 513
3 MV_1 2752
查看使用的块大小为：
SQL> select p.name,a.cnum_repl "total buffers",a.anum_repl "free buffers" from x$kcbwds a, v$buffer_pool p
2 where a.set_id=p.LO_SETID and p.name='KEEP';

NAME total buffers free buffers
---------------------------------------- ------------- ------------
KEEP 60722 1213
基本用光了，麻烦各位大神帮忙分析下剩下的keep buffer 去哪里了。。。。

[fireme5535]

没人理我么？

[小灰狼W]

从dba_segments里查出来的只是默认自动放入keep池的段 手动放入的不在此列