Performance Tuning - Question 104

What should one be your tuning goals?

A. Use as much memory as possible.

B. Use multiple copies of the code in memory.

C. Access the most possible number of blocks from disk.

D. Access the least possible number of blocks from disk.

Answer: D

Explanation:

The main goal is to access the least possible number of blocks from disk because I/O operations are significantly more expensive as memory operations.

Incorrect Answers

A: You need to use as less memory as possible.

B: You need to share the same code in the memory to reduce the memory usage.

C: The main goals is to access the least, not the most, possible number of blocks from disk

OCP: Oracle 9i Performance Tuning Study Guide, Joseph C. Johnson, p. 6-10

Chapter 1: Introduction to Performance Tuning