These views provide miscellaneous information about the current environment:
Provides information about database pipes currently defined in the database.
Provides information about all currently open database links.
Provides information about the current read/write status of all datafiles.
Lists all V$ and X$ tables defined in the kernel.
Provides a view definition for each dynamic performance view based upon the X$ tables.
Provides information on all current global transactions.
Lists each index column in the tables listed in V$FIXED_TABLE.
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.
Lists the names of all rollback segments.
Provides statistics about each rollback segment.
Provides the current values for each of the system statistics defined in V$STATNAME.
Provides information about cursor usage across all sessions.
Provides information about time spent waiting for each system event defined in V$EVENT_NAME.
Provides access to a timer that increments every 1⁄ 100th of a second.
Lists all active transactions in the system.
Lists all enqueues held by active transactions in the system.
Provides information about the number of waits and how long the system had to wait for each class of data block.
3.145.91.37