GV$ and V$ Views

TimesTen provides several views that are prefixed with GV$ and V$. These views are supported in TimesTen Scaleout and TimesTen Classic. For most V$ views, there is a corresponding GV$ view.

In TimesTen Scaleout:

• The GV$ views contain the contents of the V$ view for every element of the database.

• The V$ views contain data for the element to which your application is connected.

In TimesTen Classic:

• The GV$ views contain the same contents as their corresponding V$ view.

• The V$ views contain rows of data for the database to which your application is connected.

For example, assume you want to query the GV$ and V$BLOCK_INFO system views for information on blocks and fragmentation.

In TimesTen Scaleout:

• When you query the GV$BLOCK_INFO view, TimesTen returns the contents of the V$BLOCK_INFO contents for every element in the database. In this example, there are 6 elements, so TimesTen returns data for each of these 6 elements.

  Command> SELECT * FROM GV$BLOCK_INFO;
   
  TOTALBLOCKS, FREEBLOCKS, FREEBYTES, LARGESTFREE, ELEMENTID
  < 1549, 11, 235753720, 235717496, 1 >
  < 1548, 17, 235789368, 235728984, 3 >
  < 1547, 14, 235883704, 235855096, 5 >
  < 1549, 13, 235786520, 235762712, 2 >
  < 1548, 13, 235851352, 235827960, 6 >
  < 1544, 13, 235886264, 235851960, 4 >
  6 rows found.
  

• When you query the V$BLOCK_INFO view, TimesTen returns data for the element to which your application is connected (the local element). In this example, the local element is 1.

  Before running the query, run the set columnlabels on ttIsql command to display the column headers.

  Command> set columnlabels on;
  Command> SELECT * FROM V$BLOCK_INFO;
   
  TOTALBLOCKS, FREEBLOCKS, FREEBYTES, LARGESTFREE, ELEMENTID
  < 1549, 11, 235753720, 235717496, 1 >
  1 row found.
  

In TimesTen Classic:

• When you query the GV$BLOCK_INFO view, TimesTen returns the same contents as the V$BLOCK_INFO view. Ignore the elementId column.

  Command> SELECT * FROM GV$BLOCK_INFO;
   
  TOTALBLOCKS, FREEBLOCKS, FREEBYTES, LARGESTFREE, ELEMENTID
  < 659, 4, 118359840, 118214208, 1 >
  1 row found.
  

• When you query the V$BLOCK_INFO view, TimesTen returns data for the database to which your application is connected. Ignore the elementId column.

  Command> SELECT * FROM V$BLOCK_INFO;
   
  TOTALBLOCKS, FREEBLOCKS, FREEBYTES, LARGESTFREE, ELEMENTID
  < 659, 4, 118359840, 118214208, 1 >
  1 row found.
  

These views are categorized as follows:

• General GV$ and V$ System Views

• GV$ and V$TTSTATS System Views

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

GV$ and V$TTSTATS System Views

These views contain data based on information in the ttStats utility. These views exist in TimesTen Classic, but contain no data.

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

Table 1-5 GV$ and V$TTSTATS system views

Name	Description
SYS.GV$TTSTATS_AGGR_SCHEDULES SYS.V$TTSTATS_AGGR_SCHEDULES	Contains the metadata to determine when to do ttStats metric aggregations
SYS.GV$TTSTATS_ALERTS SYS.V$TTSTATS_ALERTS	Contains alerts for system resources Supported, but contains 0 rows
SYS.GV$TTSTATS_CKPTHIST_HIST SYS.V$TTSTATS_CKPTHIST_HIST	Contains data about the critical checkpoint metric history
SYS.GV$TTSTATS_CPU_HIST SYS.V$TTSTATS_CPU_HIST	Contains data about the CPU metric history
SYS.GV$TTSTATS_DISK_HIST SYS.V$TTSTATS_DISK_HIST	Contains data about the critical disk IO metric history
SYS.GV$TTSTATS_ELEMENT_AGGR SYS.V$TTSTATS_ELEMENT_AGGR	Contains data about aggregated metrics
SYS.GV$TTSTATS_ELEMENT_METRICS SYS.V$TTSTATS_ELEMENT_METRICS	Contains data about raw and non-aggregated metric values
SYS.GV$TTSTATS_GENERIC_HIST SYS.V$TTSTATS_GENERIC_HIST	Contains data about metrics that can be represented in generic format
SYS.GV$TTSTATS_LOGHOLD_HIST SYS.V$TTSTATS_LOGHOLD_HIST	Contains data about the history of transaction log holds
SYS.GV$TTSTATS_NETWORK_HIST SYS.V$TTSTATS_NETWORK_HIST	Contains data about the critical network metric history
SYS.GV$TTSTATS_SNAPSHOT_ANNOTATION SYS.V$TTSTATS_SNAPSHOT_ANNOTATION	Contains data about the optional user annotations for snapshots
SYS.GV$TTSTATS_SQL_COMMAND_HIST SYS.V$TTSTATS_SQL_COMMAND_HIST	Contains data about the SQL text for the most common SQL commands
SYS.GV$TTSTATS_TOP_SQL_CMD_TEXT SYS.V$TTSTATS_TOP_SQL_CMD_TEXT	Contains data about the SQL command cache metadata history
SYS.GV$TTSTATS_TXN_LOG_HIST SYS.V$TTSTATS_TXN_LOG_HIST	Contains data about the transaction log write metric history
SYS.GV$TTSTATS_VMEM_HIST SYS.V$TTSTATS_VMEM_HIST	Contains data about the history of virtual memory usage