前面几期 awr报告中的Instance Efficiency Percentages做了解释,这期照旧总结下 理论上说上述比例应接近100%
[AWR报告]Buffer Nowait
[AWR报告]Redo NoWait %
[AWR报告]Buffer Hit %
[AWR报告]In-memory Sort %
[AWR报告]Library Hit %
[AWR报告]Soft Parse %
[AWR报告]Execute to Parse %
[AWR报告]Latch Hit %
[AWR报告]Parse CPU to Parse Elapsd %
[AWR报告] % Non-Parse CPU
下期预告: Top 10 Foreground Events by Total Wait Time
其他专题: [Oracle安装文档]Oracle 9.2.0.8的安装
[安装文档]Oracle 11g RAC安装文档
|