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.
Get Oracle Database Administration: The Essential Refe now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.