Oracle Database Administration: The Essential Refe

System environment

These views provide miscellaneous information about the current environment:

V$DB_PIPES

Provides information about database pipes currently defined in the database.

V$DBLINK

Provides information about all currently open database links.

V$FILESTAT

Provides information about the current read/write status of all datafiles.

V$FIXED_TABLE

Lists all V$ and X$ tables defined in the kernel.

V$FIXED_VIEW_DEFINITION

Provides a view definition for each dynamic performance view based upon the X$ tables.

V$GLOBAL_TRANSACTION

Provides information on all current global transactions.

V$INDEXED_FIXED_COLUMN

Lists each index column in the tables listed in V$FIXED_TABLE.

V$RESOURCE_LIMIT

Shows the current utilization of system resources that can be specified in the INIT.ORA file. For each resource, the initial allocation, the current usage, and the maximum allowed value are specified.

V$ROLLNAME

Lists the names of all rollback segments.

V$ROLLSTAT

Provides statistics about each rollback segment.

V$SYSSTAT

Provides the current values for each of the system statistics defined in V$STATNAME.

V$SYSTEM_CURSOR_CACHE

Provides information about cursor usage across all sessions.

V$SYSTEM_EVENT

Provides information about time spent waiting for each system event defined in V$EVENT_NAME.

V$TIMER

Provides access to a timer that increments every ¹_{⁄ 100}th of a second.

V$TRANSACTION

Lists all active transactions in the system.

V$TRANSACTION_ENQUEUE

Lists all enqueues held by active transactions in the system.

V$WAITSTAT

Provides ...