Step-by-Step

  1. Open your AWR report.
  2. Find the “Instance Activity Stats” section.
  3. Locate the following three metrics:
    • physical reads
    • db block gets
    • consistent gets
  4. Plug the values into the formula above.
  5. 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.