主要是指db_buffer数据库缓冲的命中率
rem 应该在0.95以上,可以调整db_block_buffers
select round((1-(sum(decode(name,'physical reads',value,0))/(sum(decode(name,'db block gets',value,0)) + sum(decode(name,'consistent gets',value,0))))),2) "Data Buffer Hit Ratio" from v$sysstat;
rem 应该在0.95以上,可以调整db_block_buffers
select round((1-(sum(decode(name,'physical reads',value,0))/(sum(decode(name,'db block gets',value,0)) + sum(decode(name,'consistent gets',value,0))))),2) "Data Buffer Hit Ratio" from v$sysstat;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货