SYS.V$TTSTATS_TOP_SQL_CMD_TEXT

This view contains the SQL text for the most common SQL commands.

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_TOP_SQL_CMD_TEXT

Columns

Column name	Type	Description
SQLCMDID	TT_BIGINT NOT NULL	The unique identifier of the command
SQL_HASH	BINARY(16) NOT NULL	A hash of the SQL text
NUM_PRIVATE_CMDS	TT_INTEGER	The number of private commands for the SQL text
OWNER	VARCHAR2(31) INLINE NOT NULL	The user who created the command
QUERYTEXT	VARCHAR2(409600) NOT INLINE NOT NULL	The complete SQL text for the current command
ELEMENTID	TT_INTEGER NOT NULL	The element from which the snapshot was collected