ttSQLCmdCacheInfoGet

This procedure displays information about the commands in the TimesTen SQL command cache.

Required Privilege

This procedure requires no privilege.

Usage in TimesTen Scaleout and TimesTen Classic

This procedure is supported in TimesTen Classic.

TimesTen Scaleout applications can call this built-in procedure.

In TimesTen Scaleout, this procedure runs locally on the element from which it is called.

Related Views

This procedure has these related views.

Syntax

ttSQLCmdCacheInfoGet()

Parameters

ttSQLCmdCacheInfoGet has no parameters.

Result Set

ttSQLCmdCacheInfoGet returns the result set:

Column	Type	Description
`cmdCount`	`TT_INTEGER NOT NULL`	Number of commands in the cache.
`freeableCount`	`TT_INTEGER NOT NULL`	Count of number of freeable commands that can be garbage collected by the subdaemon at that moment. This number is obtained by examining the command information.
`size`	`TT_BIGINT NOT NULL`	The current total space allocated to store all the cached commands, in bytes.

Examples

To display the command count, freeable command count, and total space allocated to the command cache, use:

Command> call ttSQLCmdCacheInfoGet ();
< 5,4,12316 >
1 row found