1. System Tables and Views Reference
  2. System Tables and Views 
  3. SYS.GV$SQL_CMD_CACHE

SYS.GV$SQL_CMD_CACHE

This view contains data about all the prepared SQL statements in the TimesTen SQL command cache.

Usage with TimesTen Scaleout

This view contains the contents of the SYS.V$SQL_CMD_CACHE view for every element in the database.

Usage with TimesTen Classic

This view contains data for the database to which the application is connected. It has the same contents as SYS.V$SQL_CMD_CACHE.

Related view

SYS.V$SQL_CMD_CACHE

Columns

See ttSQLCmdCacheInfo in the Oracle TimesTen In-Memory Database Reference for information on the columns in this view, including the column name, data type, and description.

In addition to these columns, the view contains the elementId column of type TT_INTEGER NOT NULL that contains the element id for an element in the database. Ignore this column in TimesTen Classic.