ttSQLCmdCacheInfoGet

Description

Gets command statistics update information. This procedure can be useful for certain operations, such as CREATE INDEX or DROP INDEX and other DDL operations that alter objects.

Required privilege

This procedure requires no privilege.

Syntax

ttSQLCmdCacheInfoGet()

Parameters

ttSQLCmdCacheInfoGet has no parameters.

Result set

ttSQLCmdCacheInfoGet returns the result set:

Parameter	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.

Examples

To generate a list of all TimesTen instance users, use:

Command> CALL ttSQLCmdCacheInfoGet;
< 5,4,12316 >
1 row found