V$ System Views

The following table shows the V$ system views:

Table 1-4 V$ system views

Name	Description
SYS.V$BACKUP_STATUS	Contains data about the current or last backup of the database.
SYS.V$BLOCK_INFO	Contains data about perm blocks and the amount of block-level fragmentation in the database.
SYS.V$BOOKMARK	Contains data about the transaction log.
SYS.V$CKPT_CONFIG	Contains data about the background checkpointer.
SYS.V$CKPT_HISTORY	Contains data about the last eight checkpoints.
SYS.V$COMMIT_BUFFER_STATS	Contains data about the number of commit buffer overflows and the high watermark for memory used by the transaction reclaim records during the transaction commit process.
SYS.V$CONFIGURATION	Contains data about most, but not all, connection attributes for the current connection.
SYS.V$CONTEXT	Contains data about the context value of the current connection.
SYS.V$DATASTORE_STATUS	Contains data about the list of processes connected to the database.
SYS.V$DB_COMPACT_CONFIG	Contains data about automatic database compaction.
SYS.V$DB_CONFIG	Contains data about the value of a system parameter.
SYS.V$DB_WRTE_CONCURRENCY_MODE	Contains data about the write concurrency mode of the database and the status of write concurrency mode operations and transitions.
SYS.V$DEADLOCKCYCLES	Contains data about the transactions of the participants in the cycle.
SYS.V$DEADLOCKS	Contains data about deadlock cycles.
SYS.V$DEADLOCKVICTIMS	Contains data about deadlock victims.
SYS.V$ERROR	Contains data about errors for PL/SQL objects
SYS.V$EXECUTION_TIME_HISTOGRAM	Contains a histogram of SQL execution times for either a single SQL command or all SQL commands if the command cache sampling is enabled
SYS.V$HEAP_INFO	Contains the size and usage of heap memory
SYS.V$HOST_NAME	Contains the name of the host
SYS.V$INDEX_ADVICE_OUTPUT	Contains index recommendations from the last recorded capture at the specified level
SYS.V$LATCH_STATS	Contains data about latch statistics
SYS.V$LOG_HOLDS	Contains data about transaction log holds
SYS.V$MONITOR	Contains data about system performance Related view: SYS.V$SYSTEMSTATS
SYS.V$OPT_COL_STATS	Contains statistics information in text format
SYS.V$OPT_FLAG	Contains the optimizer flag settings for the current transaction
SYS.V$OPT_JOIN_ORDER	Contains data about the identifiers in the stored objects
SYS.V$OPT_MAX_CMD_FREELIST_CNT	Contains data about the objects that are stored in the database
SYS.V$OPT_ORDER	Contains data about the join order of the last prepared or executed SQL statement (SELECT, UPDATE, DELETE, and INSERT SELECT) in the current transaction
SYS.V$OPT_STATS	Contains the set of statements required to restore the table statistics to the current state
SYS.V$PLSQL_MEMORY_STATS	Contains result statistics about PL/SQL library cache performance and activity
SYS.V$REDUNDANT_INDEX	Contains data about redundant indexes
SYS.V$REPSTATS	Contains data about per subscriber statistics for replication. When parallel replication or parallel asynchronous writethrough (AWT) features are enabled, the statistics are per track. If these features are not enabled, the statistics are for track 0.
SYS.V$SESSION	Contains data about each current connection in TimesTen.
SYS.V$SQL_CMD_CACHE	Contains data about the prepared SQL statements in the TimesTen SQL command cache
SYS.V$SQL_CMD_CACHE_INFO	Contains data about the commands in the TimesTen SQL command cache
SYS.V$SQL_CMD_QUERY_PLAN	Contains the detailed runtime query plans for SQL statements in the TimesTen SQL command cache
SYS.V$STATS_CONFIG	Contains data about the parameters of the ttStats utility
SYS.V$SYSTEMSTATS	Contains data about system monitoring metrics
SYS.V$TABLE_SIZES	Contains data about the space used by a table or materialized view, including indexes
SYS.V$VERSION	Contains TimesTen release information
SYS.V$XACT_ID	Contains the transaction ID information for interpreting lock messages