Oracle Parallel Server
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
Oracle Parallel Server
These views are specific to an Oracle Parallel Server environment:
- V$ACTIVE_INSTANCES
Lists all current instances that have the database mounted.
- V$BH
Provides the status and pings of every data buffer in the System Global Area (SGA).
- V$CACHE
Provides information about the block header of every object the current instance has in its SGA.
- V$CACHE_LOCK
Provides the lock status of every data block the current instance has in its SGA.
- V$CLASS_PING
Shows statistics on the number of pings per data block class.
- V$DLM_CONVERT_LOCAL
Shows elapsed times for local DLM lock conversions.
- V$DLM_CONVERT_REMOTE
Shows elapsed times for remote DLM lock conversions.
- V$DLM_LATCH
Shows the total count and number of immediate gets of DLM latches acquired by latch type.
- V$DLM_LOCKS
Shows all DLM locks and lock requests that are blocked or are blocking other lock requests.
- V$DLM_MISC
Provides statistics on various DLM parameters.
- V$FALSE_PING
Lists buffers that are getting excessive pings because they are covered under a different lock. Buffers that are identified can be remapped using the INIT.ORA parameter GC_FILES_TO_LOCKS.
- V$FILE_PING
Shows the number of block pings per datafile.
- V$LOCK_ACTIVITY
Provides an overall view of DLM locks within the current instance.
- V$LOCK_ELEMENT
Provides information about each PCM lock in the data buffers.
- V$LOCKS_WITH_COLLISIONS
Shows locks with high numbers of false pings.
- V$PING
A subset of V$CACHE; shows only those buffers that have been pinged at least once.
-
No Comment