Which lock modes are required for which table action? How compatibility of locks works?

The following table describes what lock modes on DML enqueues are gotten for table operations in a standard Oracle installation.

The compatibility of lock modes usually are represented by the following matrix:

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *