What Are The Different Types Of Locking Modes?

1.	What Are The Different Types Of Locking Modes?
Answer» Lock modes VARY from 0 to 6 in order of increasing exclusively, GIVEN as follows: No lock (0) Shared Row Exclusive lock (3) Shared lock (4) Exclusive lock (6) You can get the information on modes of TM and TX locks by using the LMODE and REQUEST columns. Both the locks use the same numbering for lock modes. DML requires a Shared Row Exclusive lock, that is, TM-3. DDL requires an Exclusive lock, that is, TM-6. Lock modes vary from 0 to 6 in order of increasing exclusively, given as follows: You can get the information on modes of TM and TX locks by using the LMODE and REQUEST columns. Both the locks use the same numbering for lock modes.

Answer»

Lock modes VARY from 0 to 6 in order of increasing exclusively, GIVEN as follows:

You can get the information on modes of TM and TX locks by using the LMODE and REQUEST columns. Both the locks use the same numbering for lock modes.

Lock modes vary from 0 to 6 in order of increasing exclusively, given as follows:

You can get the information on modes of TM and TX locks by using the LMODE and REQUEST columns. Both the locks use the same numbering for lock modes.

Discussion