Performance Tuning - Question 083

Which two views can be used to detect lock contention? (Choose two)

A. V$LOCK

B. V$LOCKED_OBJECT

C. V$LOCK_CONTENTION

Answer: A, B

Explanation:

When left to its default mechanisms, Oracle generally does a very effective job of managing locking. When it does occur, lock contention can be identified using the V$LOCK and V$LOCKED_OBJECT dynamic performance views, the DBA_WAITERS and DBA_BLOCKS data dictionary views, and the OEM Performance Manager GUI.

Incorrect Answers

C: There is no V$LOCK_CONTENTION data dictionary view in Oracle.

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

Chapter 9: Tuning Contention