oracle性能查询及优化
Tony_yxxy
这个作者很懒,什么都没留下…
展开
-
oracle查询命中率
librarycache命中率:select sum(pinhits)/sum(pins)*100 from v$librarycacherowcache命中率:select sum(gets),sum(getmisses),100*sum(gets-getmisses)/sum(gets) from v$rowcache where gets>0转载 2015-04-16 16:04:15 · 428 阅读 · 0 评论 -
oracle内存中bufferCache修改
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转载 2015-04-21 16:15:34 · 1565 阅读 · 0 评论 -
oracle把表数据放入内存
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.PurposeThe purpose of the转载 2015-07-28 11:31:54 · 2978 阅读 · 0 评论