1.

What Are Different Types Of Locks?

Answer»

There are two different types of locks, which are given as follows:

  • System locks – Held for a very brief period of time and CONTROLLED by Oracle.
  • User locks – CREATED and managed USING dbms_lock package.

    Different types of user locks are given as follows:
    • The UL lock – Defined with the dbms_lock package.
    • The TX lock – ACQUIRED once for every transaction. It is a row transaction lock.
    • The TM lock – Acquired once for each object, which is being changed. It is a DML lock. The IDI column identifies the object being modified.

There are two different types of locks, which are given as follows:


Discussion

No Comment Found

Related InterviewSolutions