FAQ about Detecting and Resolving Locking Conflicts
CONTENTS
========
1. How does Oracle handle locking?
2. How to find the resource definitions?
3. Which lock modes are required for which table action?
4. How compatibility of locks works?
5. Which views can be used to detect locking problems?
6. Which tools are there to diagnostic locking issues?
7. How to detect locking situations?
8. How to resolve locking situations?
9. How to resolve deadlock situations?
10. Unusual locking problems
11. How to use dbms_lock?