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 |
---|---|---|
|
|
Number of commands in the cache. |
|
|
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. |
|
|
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
See Also