Performance Tuning - Question 118

What may happen if you size your rollback segments too small?

A. The long transaction switches to SYSROL rollback.

B. The long transaction fails for lack of rollback space.

C. The long transaction hangs until the DBA alters MINEXTENTS.

D. The long transaction is forces to switch to another rollback segment.

Answer: B

Explanation:

The long transaction can fail for lack of rollback space if you size your rollback segments too small.

Incorrect Answers

A: Transaction cannot be switched to another rollback segment.

C: MINEXTENTS parameter has nothing to do with rollback segments. The long transaction will just fail.

D: Transaction cannot be switched to another rollback segment.

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

Chapter 7: Tuning Redo Mechanisms