General GV$ and V$ System Views

Table 1-4 shows the general GV$ and V$ views. The GV$ views are listed first in the name column of the table.

Table 1-4 General GV$ and V$ system views

Name	Description
SYS.GV$BACKUP_STATUS SYS.V$BACKUP_STATUS	Contains data about the current or last backup of the database (or element(s))
SYS.GV$BLOCK_INFO SYS.V$BLOCK_INFO	Contains data about perm blocks and the amount of block-level fragmentation in the database (or element(s))
SYS.GV$BOOKMARK SYS.V$BOOKMARK	Contains data about the transaction log
SYS.GV$CACHE_GROUP_INTERVAL_STATS SYS.V$CACHE_GROUP_INTERVAL_STATS	contains data about the last 10 autorefresh cycles for a particular autorefresh interval
SYS.GV$CACHE_GROUP_STATS SYS.V$CACHE_GROUP_STATS	Contains data about the last ten autorefresh transactions on the specified cache group
SYS.GV$CKPT_CONFIG SYS.V$CKPT_CONFIG	Contains data about the background checkpointer
SYS.GV$CKPT_HISTORY SYS.V$CKPT_HISTORY	Contains data about the last eight checkpoints
SYS.GV$COMMIT_BUFFER_STATS 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.GV$CONFIGURATION SYS.V$CONFIGURATION	Contains data about most, but not all, connection attributes for the current connection
SYS.GV$CONTEXT SYS.V$CONTEXT	Contains data about the context value of the current connection
SYS.GV$DATASTORE_STATUS SYS.V$DATASTORE_STATUS	Contains data about the list of processes connected to the database (or element(s))
SYS.GV$DB_COMPACT_CONFIG SYS.V$DB_COMPACT_CONFIG	Contains data about automatic database compaction
SYS.GV$DB_CONFIG SYS.V$DB_CONFIG	Contains data about the value of a system parameter
SYS.GV$DB_WRTE_CONCURRENCY_MODE 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.GV$DEADLOCKCYCLES SYS.V$DEADLOCKCYCLES	Contains data about the transactions of the participants in the cycle
SYS.GV$DEADLOCKS SYS.V$DEADLOCKS	Contains data about deadlock cycles
SYS.GV$DEADLOCKVICTIMS SYS.V$DEADLOCKVICTIMS	Contains data about deadlock victims
SYS.GV$DISTRIBUTION_CURRENT SYS.V$DISTRIBUTION_CURRENT	Contains a subset of the rows in the SYS.GV$DISTRIBUTION_MAP view in the current installed distribution map Supported in TimesTen Scaleout only
SYS.GV$DISTRIBUTION_MAP SYS.V$DISTRIBUTION_MAP	Contains the grid topology for the elements of the database (if global) or the local element (if local) Supported in TimesTen Scaleout only
SYS.GV$DISTRIBUTION_STATE SYS.V$DISTRIBUTION_STATE	Contains data about the state of each element Supported in TimesTen Scaleout only
SYS.GV$DISTRIBUTION_VERSION SYS.V$DISTRIBUTION_VERSION	Contains the current version number of the distribution map for the elements of the database (if global) or for the local element (if local) Supported in TimesTen Scaleout only
SYS.GV$EPOCH_LATEST SYS.V$EPOCH_LATEST	Contains epoch values for all the elements in the database (if global) or for the local element (if local) Supported in TimesTen Scaleout only
SYS.GV$EPOCH_SESSION SYS.V$EPOCH_SESSION	Contains the epoch identifier of the last epoch created by the connection Supported in TimesTen Scaleout only
SYS.GV$ERROR SYS.V$ERROR	Contains data about errors for PL/SQL objects
SYS.GV$EXECUTION_TIME_HISTOGRAM 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.GV$GRIDSTATS SYS.V$GRIDSTATS	Contains data about statistics for databases in TimesTen Scaleout Supported in TimesTen Scaleout only
SYS.GV$HEAP_INFO SYS.V$HEAP_INFO	Contains the size and usage of heap memory
SYS.GV$HOST_NAME SYS.V$HOST_NAME	Contains the name of the host
SYS.GV$INDEX_ADVICE_OUTPUT SYS.V$INDEX_ADVICE_OUTPUT	Contains index recommendations from the last recorded capture at the specified level
SYS.GV$LATCH_STATS SYS.V$LATCH_STATS	Contains data about latch statistics
SYS.GV$LOG_HOLDS SYS.V$LOG_HOLDS	Contains data about transaction log holds
SYS.GV$MONITOR SYS.V$MONITOR	Contains data about system performance Related views: SYS.GV$SYSTEMSTATS and SYS.V$SYSTEMSTATS
SYS.GV$OPT_COL_STATS SYS.V$OPT_COL_STATS	Contains statistics information in text format
SYS.GV$OPT_FLAG SYS.V$OPT_FLAG	Contains the optimizer flag settings for the current transaction
SYS.GV$OPT_JOIN_ORDER SYS.V$OPT_JOIN_ORDER	Contains data about the identifiers in the stored objects
SYS.GV$OPT_MAX_CMD_FREELIST_CNT SYS.V$OPT_MAX_CMD_FREELIST_CNT	Contains data about the objects that are stored in the database
SYS.GV$OPT_ORDER 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.GV$OPT_STATS SYS.V$OPT_STATS	Contains the set of statements required to restore the table statistics to the current state
SYS.GV$PLSQL_MEMORY_STATS SYS.V$PLSQL_MEMORY_STATS	Contains result statistics about PL/SQL library cache performance and activity
SYS.GV$REDUNDANT_INDEX 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. There is no SYS.GV$REPSTATS view.
SYS.V$SESSION	Contains data about each current connection in TimesTen. This view is not supported in TimesTen Scaleout. There is no SYS.GV$SESSION view.
SYS.GV$SQL_CMD_CACHE SYS.V$SQL_CMD_CACHE	Contains data about the prepared SQL statements in the TimesTen SQL command cache
SYS.GV$SQL_CMD_CACHE_INFO SYS.V$SQL_CMD_CACHE_INFO	Contains data about the commands in the TimesTen SQL command cache
SYS.GV$SQL_CMD_QUERY_PLAN SYS.V$SQL_CMD_QUERY_PLAN	Contains the detailed runtime query plans for SQL statements in the TimesTen SQL command cache
SYS.GV$STATS_CONFIG SYS.V$STATS_CONFIG	Contains data about the parameters of the ttStats utility
SYS.GV$SYSTEMSTATS SYS.V$SYSTEMSTATS	Contains data about system monitoring metrics
SYS.GV$TABLE_SIZES SYS.V$TABLE_SIZES	Contains data about the space used by a table or materialized view, including indexes
SYS.GV$VERSION SYS.V$VERSION	Contains TimesTen release information
SYS.GV$XACT_ID SYS.V$XACT_ID	Contains the transaction ID information for interpreting lock messages