Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

One of the recommended ways to tune statements is to reduce the number of logical I/Os, because logical I/Os tend to dominate response time. It is important to understand how the number of logical I/Os varies over time. The instance statistics in the Statistics tab re-enforce the resource consumption figures observed in the Activity tab.

Anchor
Examiningconsistentgets
Examiningconsistentgets
Examining consistent gets

We can tune statements by examining the current number of consistent gets for a period of time.

...