There are two different types of locks, which are given as follows:
1. System locks — Held for a very brief period of time and controlled by Oracle.
2. User locks — created and managed using dbmsjock package.
Different types of user locks are given as follows:
i. The UL lock— Defined with the dbmsjock package.
ii. The TXlock—Acquired once for every transaction. It is a row transaction lock.
iii. The TMlock—Acquired once for each object, which is being changed. It is a DML lock. The ID1 column identifies the object being modified.
1. System locks — Held for a very brief period of time and controlled by Oracle.
2. User locks — created and managed using dbmsjock package.
Different types of user locks are given as follows:
i. The UL lock— Defined with the dbmsjock package.
ii. The TXlock—Acquired once for every transaction. It is a row transaction lock.
iii. The TMlock—Acquired once for each object, which is being changed. It is a DML lock. The ID1 column identifies the object being modified.