Home » RDBMS Server » Server Administration » Latches in Oracle
Latches in Oracle [message #56671] Wed, 16 April 2003 06:08 Go to next message
Praveen Kumar
Messages: 21
Registered: December 2001
Junior Member
What is latches in oracle.Pls give a brief description..

Report message to a moderator

Re: Latches in Oracle [message #56724 is a reply to message #56671] Sun, 20 April 2003 04:26 Go to previous message
Frank Naude
Messages: 4593
Registered: April 1998
Senior Member
Hi,

A latch is an internal Oracle mechanism used to protect data structures in the SGA from simultaneous access. Atomic hardware instructions like TEST-AND-SET are used to implement latches. Latches are more restrictive than locks in that they are always exclusive. Latches are never queued, but will spin or sleep until they obtain a resource, or time out.

For more details, see the Internals FAQ at http://www.orafaq.net/faqdbain.htm

Best regards.

Frank

Report message to a moderator

Previous Topic: installation of oracle 8i and forms 6
Next Topic: Nested for loop cursors or Joins????
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Feb 14 20:03:08 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.