Step-by-Step
- Open your AWR report.
- Find the “Instance Activity Stats” section.
- Locate the following three metrics:
- physical reads
- db block gets
- consistent gets
- Plug the values into the formula above.
- Multiply by 100 for a percentage.
A high ratio may look healthy but can mask inefficient access patterns. Use this metric as a supporting clue, not a primary diagnostic.