1.

What Is A User-defined Lock?

Answer»

Oracle manages DATABASE resources through locking mechanism. These locks are usually managed by the SYSTEM and are released on COMMIT or rollback of a transaction.
HOWEVER, Oracle has provided this functionality to the users so that they can create user-defined locks. These locks are similar to system created locks in functionality but are not released automatically when transaction commits or rollbacks. THEREFORE, a user has to be extremely careful while using user-defined locks.

Oracle manages database resources through locking mechanism. These locks are usually managed by the system and are released on commit or rollback of a transaction.
However, Oracle has provided this functionality to the users so that they can create user-defined locks. These locks are similar to system created locks in functionality but are not released automatically when transaction commits or rollbacks. Therefore, a user has to be extremely careful while using user-defined locks.


Discussion

No Comment Found

Related InterviewSolutions