What are latches in Oracle 9i Database? Can you name the latches.How do you resolve contention on latches.

  • Interview Candidate
  • 3
  • 2608

Showing Answers 1 - 3 of 3 Answers

kumar1974

  • Jan 22nd, 2008
 

Latches are the seriliazation mechanisms to protect shared data structures in System Global Area. Example Latches protect the list of users presently accessing the database and protect the data structures that describes the data blocks present in the buffer cache.

The implementation of Latches is Operating System Dependent.
V$LATCH  view is used to query the latches.

Regards

Kumar

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions