yaoxinook的专栏

librarycache命中率： select  sum(pinhits)/sum(pins)*100 from v$librarycache rowcache命中率： select sum(gets),sum(getmisses),100*sum(gets-getmisses)/sum(gets) from v$rowcache where gets>0

1，查看曲线，找出适合的值 一般情况下，我们选取estd_physical_read_factor为1的值为最佳，或者为sga_max_size/2~sga_max_size*2/3。 select size_for_estimate "Cache Size (MB)",size_factor,buffers_for_estimate "buffers", estd_physical_rea

Oracle's buffer cache   The buffer cache is part of the SGA. It holds copies of data blocks so as they can be accessed quicker by oracle than by reading them off disk. Purpose The purpose of the