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