SYS.V$TTSTATS_SQL_COMMAND_HIST

This view contains data about the SQL command cache metadata history.

Usage with TimesTen Scaleout

This view contains data for the local element.

Usage with TimesTen Classic

This view exists in TimesTen Classic, but contains no data.

Related view

SYS.GV$TTSTATS_SQL_COMMAND_HIST

Columns

Column name	Type	Description
ID	TT_BIGINT NOT NULL	The snapshot identifier
SQLCMDID	TT_BIGINT NOT NULL	The unique identifier of a command
ALT_PRIV_CMD_ID	TT_BIGINT	The SQLCMDID of another SQL command that has the same SQL text
EXECUTIONS	TT_BIGINT NOT NULL	The number of executions for the command
COST	NUMBER	The cost of the execution as measured by the product of (EXECUTION * LASTEXECUTETIME) for the command
PERCENT_EXECS	NUMBER	The percentage of executions for the command
PERCENT_LATENCY	NUMBER	The percentage of the latency for the command (Used to determine if the command is running slowly)
PREPARES	TT_BIGINT NOT NULL	The number of prepares for the command
REPREPARES	TT_BIGINT NOT NULL	The number of reprepares for the command
EXECLOC	TT_TINYINT NOT NULL	The execution location. Valid values are: 0: Local (TimesTen Scaleout) 1: Remote 2: Global (TimesTen Scaleout) In TimesTen Classic, value is 0.
MINEXECUTETIME	BINARY_DOUBLE NOT NULL	If the value of SqlCmdSampleFactor is greater than 0, minimum execution time for the statement (expressed in seconds). Otherwise, the value is 0.0.
MAXEXECUTETIME	BINARY_DOUBLE NOT NULL	The maximum wall clock execution time (expressed in seconds) for the statement.
LASTEXECUTETIME	BINARY_DOUBLE NOT NULL	The last measured execution time of the command (expressed in seconds)
FETCHCOUNT	TT_BIGINT NOT NULL	The total number of fetch executions for the statement
STARTTIME	TT_TIMESTAMP	The time when the statement was last executed
COLLECTED_AT	TT_TIMESTAMP NOT NULL	The time when the snapshot was collected
ELEMENTID	TT_INTEGER NOT NULL	The element from which the snapshot was collected