Topic : Latch & Locks

What are different types of locks?


Answer :

There are different types of locks; which are given as follows:
System locks - controlled by oracle and held for a very brief period of time.
User locks - Created and managed using dbms_lock package.
Different types of user locks are given as follows
UL Lock - Defined with dbms_lock package.
TX Lock - Acquired once for every transaction. It isa row transaction lock.
TM Lock - Acquired once for each object; which is being changed. It is a DML lock. The ID1 column identifies the object being modified.

Show Answer Discuss

What is a latch and explain its significance?


Answer :

- Latch is an on/off switch in oracle that a process must access in order to perform certain type of activities.
- They enforce serial access to the resources and limit the amount of time for which a single process can use a resource.
- A latch is

Show Answer Discuss