Look Inside the Locking Mechanism
Locking is not a problem you can fix by adding CPU or memory, you really need to understand what’s going on and fix the issue. For that you’ll have to understand what types of locks Oracle has, when they are acquired and released, what affects locking and more. Come and learn everything you need to.
Locking issues have always been an interesting topic. This is one of the most important features that maintain the integrity of our database.
Why do we need the locking mechanism? What locking modes and types are there? What does Oracle lock during DML and DDL operations? How constraints and indexes are affected by and affecting locks? These are some of the questions that this session handles.
The session also includes live demos for some advanced and interesting scenarios, and shows how to query relevant data dictionary views.