数据缓冲区命中率.docxVIP

数据缓冲区命中率：51Testing软件测试网,eO9w2X2@SQL select value from v$sysstat where name =physical reads; 51Testing软件测试网tlWt*A|C3WV[SQL select value from v$sysstat where name =physical reads direct; }J ~t7M,nFW0SQL select value from v$sysstat where name =physical reads direct (lob); 0K[EC8kA D{6W0SQL select value from v$sysstat where name =consistent gets; [0Gl7KT_^ l0SQL select value from v$sysstat where name = db block gets; 51Testing软件测试网$uF3HU1SaY这里命中率的计算应该是51Testing软件测试网P[ w7p7~%q*}fj令 x = physical reads direct + physical reads direct (lob) 51Testing软件测试网1{V$jl6l!N]h命中率 =100 - ( physical reads - x) / (consistent gets + db block gets - x)*100 51Testing软件测试网e*Y rW fPwSQ+|通常如果发现命中率低于90%,则应该调整应用可可以考虑是否增大数据缓冲区51Testing软件测试网$zk:bQ\^W2、共享池的命中率：L/]%Wg.d`$? fW0SQL select sum(pinhits-reloads)/sum(pins)*100 hit radio from v$librarycache; 51Testing软件测试网 tK Ed g?{s7}(jGN假如共享池的命中率低于95%,就要考虑调整应用（通常是没使用bind var ）或者增加内存select size_for_estimate, estd_physical_read_factor, estd_physical_reads from v$db_cache_adviceselect * from v$shared_pool_adviceSELECT shared_pool_size_for_estimate Size of Shared Pool in MB, shared_pool_size_factor Size Factor, estd_lc_time_saved Time Saved in secFROM v$shared_pool_advice;select * from v$sga_target_adviceSELECTround(pga_target_for_estimate /1024/1024,2)PGA(MB), pga_target_factor, estd_pga_cache_hit_percentage, estd_overalloc_countFROM v$pga_target_advice;-----------查看PGA的大小建议select pga_target_for_estimate size,pga_target_factor factor,estd_extra_bytes_rw/1000000 extra Mb r/w, estd_overalloc_count over alloctionsfrom v$pga_target_advice;----------db_cache_advice建议值-------SELECT ???? size_for_estimate, buffers_for_estimate, ????????????????? estd_physical_read_factor, estd_physical_reads FROM V$DB_CACHE_ADVICE WHERE ????? name = DEFAULT AND ??????? block_size = ????????????????? (SELECT value FROM V$PARAMETER ???? ??????? WHERE name = db_block_size) AND ??????? advice_status = ON;---------------shared_pool_advice　建议值----select SHARED_P