Oracle — Table lock modes

Here is a post with a few links to previous blog/article/video about Oracle table lock modes. And remember that in 12cR2 the event 10704 has been replaced by UTS tracing:

alter session set events 'trace[ksq] disk medium';

Agenda was:

  • 0:45 — Basics
  • 5:03 — TX lock demo
  • 9:30 — TM lock info
  • 21:04 — Foreign key index demo
  • 28:48–10g, 11g, 12c locking differences
  • 41:50 — New online operations in 12c
  • 46:26 — Event 10704 trace
  • 50:34 — Deadlock demo
  • 53:42 — Q&A

The slides seem to be there:

--

--

Developer Advocate at Yugabyte, Open Source distributed SQL database 🚀 Also Oracle ACE Director, Oracle Certified Master, AWS Data Hero, OakTable member

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Franck Pachot

Developer Advocate at Yugabyte, Open Source distributed SQL database 🚀 Also Oracle ACE Director, Oracle Certified Master, AWS Data Hero, OakTable member