各位,有个奇怪的现象谁知道怎么回事?
缓冲区的大小设置为:3072M,可是Enterprise Manager Console页面显示为:-1073741824,命中率为:80.29%。
而我用:
SELECT physical_reads, db_block_gets, consistent_gets, NAME,
100 * ( 1 - ( physical_reads / (consistent_gets + db_block_gets - physical_reads))) "Data Buffer Hit Ratio"
FROM v$buffer_pool_statistics;查出来命中率为:99.0221900766764%
请问这是怎么回事啊?
缓冲区的大小设置为:3072M,可是Enterprise Manager Console页面显示为:-1073741824,命中率为:80.29%。
而我用:
SELECT physical_reads, db_block_gets, consistent_gets, NAME,
100 * ( 1 - ( physical_reads / (consistent_gets + db_block_gets - physical_reads))) "Data Buffer Hit Ratio"
FROM v$buffer_pool_statistics;查出来命中率为:99.0221900766764%
请问这是怎么回事啊?
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/751371/viewspace-563124/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/751371/viewspace-563124/