Home / Educational Content / Database & Technology / Oracle Database / Internals and Performance Bootcamp: How Oracle Locking Works

Internals and Performance Bootcamp: How Oracle Locking Works

Ever wondered how Oracle locks a row, or a table? Is there a master lock manager? No, there is not. In this session you will learn how Oracle manages the locking with demos, how ITL slots are used and how you can avoid the issues related to ITL slots. Also learn how unindexed Foreign Keys cause locking issues, how undo segment is used, and how you can use this knowledge to diagnose performance issues.

Internals and Performance Bootcamp: How Oracle Locking Works