Performance Tuning - Question 106

What are two possible causes of lock contention? (Choose two)

A. Uncommitted changes.

B. Too many rollback segments.

C. Improperly sized redo logs.

D. Shared pool is sized too large.

E. Other protocols imposing unnecessarily high locking levels.

Answer: A, E

Explanation:

Lock contention can arise because of uncommitted changes and unnecessarily table level locks.

Incorrect Answers

B: Large amount of rollback segments decrease possibility of lock contention.

C: Lock contention is not related with the size of redo logs.

D: Lock contention is not related with shared pool size.

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

Chapter 9: Tuning the Contention