| January 01, 2008 05:26:54 |
#1 |
| kumar1974 |
Member Since: January 2008 Total Comments: 5 |
RE: What are latches in Oracle 9i Database? Can you name the latches.How do you resolve contention on latches.
|
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 |
| |
