ttSQLCmdCacheInfoGet

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

Required Privilege

This procedure requires no privilege.

Related Views

This procedure has this related view.

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