Oracle Database Administration: The Essential Refe

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.