Locks and latches
by Brian Laskey, David C. Kreines
Oracle Database Administration: The Essential Refe
- Dedication
- Preface
- I. DBA Tasks
- 1. Introduction
- 2. Installation
- 3. Maximizing Oracle Performance
- 4. Preventing Data Loss
- 5. Oracle Networking
- Oracle Names
- MultiProtocol Interchange
- Connecting to Non-Oracle Databases
- Network Manager Data Storage
- Using Network Manager
- Files Created by Network Manager
- Oracle Net8 Assistant
- Manual Network Configuration
- Sample SQL*Net Files
- SQL*Net Troubleshooting
- 6. Security and Monitoring
- 7. Auditing
- 8. Query Optimization
- 9. Oracle Tools
- 10. The Oracle Instance
- 11. The Oracle Database
- 12. Initialization Parameters
- 13. SQL Statements for the DBA
- SQL Commands by Task
- SQL Command Syntax
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- column_constraint_clause
- auto_extend_clause
- for_clause
- filespec
- autoextend_clause
- global_index_clause
- local_index_clause
- table_constraint_clause
- table_ref_clause
- column_ref_clause
- column_constraint_clause
- index_organization_clause
- segment_attrib_clause
- partition_clause
- autoextend_clause
- 14. The Oracle Data Dictionary
- Static Data Dictionary Views
- Dynamic Performance Data Dictionary Views
- 15. System Privileges and Initial Roles
- 16. Tools and Utilities
Locks and latches
These views provide information about the status of locks and latches within the instance:
- V$ACCESS
Lists all locked objects in the database and the sessions accessing these objects.
- V$BUFFER_POOL
Provides information about the available buffer pools. The number of buffer pools is related to the INIT.ORA parameter DB_BLOCK_LRU_LATCHES.
- V$ENQUEUE_LOCK
Lists all locks owned by enqueue state objects.
- V$LATCH
Provides statistics for all latches. If the latch is a parent latch, provides a summation of the statistics for each of its children latches.
- V$LATCH_CHILDREN
Provides statistics for all children latches.
- V$LATCH_MISSES
Provides statistics about all failures to acquire a latch.
- V$LATCH_PARENT
Provides statistics for all parent latches.
- V$LATCHHOLDER
Provides information about current latch holders.
- V$LATCHNAME
Provides a decoded latch name for every latch listed in V$LATCH. There is a one-to-one correspondence between these two views.
- V$LOCK
Lists all locks held and all outstanding requests for locks or latches.
- V$LOCKED_OBJECT
Lists all objects currently locked by transactions within the system.
- V$RESOURCE
Contains the names, types, and addresses of all resources in the system.
-
No Comment