性能优化
-
编辑 删除
oracle性能优化参数调整
1.SHARE_POOL_SIZE数据字典的命中率计算：select ((1 - (Sum(GetMisses) / (Sum(Gets) + Sum(GetMisses)))) * 100) "Hit Rate" from V$RowCachewhere Gets + GetMisses <> 0;数据字典的命中率低于95%可考虑提升SHA...
