Monitoring and Detecting Lock Contention

After completing this lesson, you should be able to do the following: Define levels of locking Identify causes of contention Prevent locking problems Use Oracle utilities to detect lock contention Resolve contention in an emergency Resolve deadlock conditions