ttCacheAutorefIntervalStatsGet

Required Privilege

This procedure requires no privileges.

Usage in TimesTen Scaleout and TimesTen Classic

This procedure is supported in both TimesTen Classic and TimesTen Scaleout.

Related Views

This procedure has no related views.

Syntax

ttCacheAutorefIntervalStatsGet (autoRefInterval, isStatic)

Parameters

ttCacheAutorefIntervalStatsGet has the parameters:

Parameter Type Description

Parameter	Type	Description
`autoRefInterval`	`TT_BIGINT NOT NULL`	The `autorefreshInterval` designates the cache group (the one with this autorefresh interval value) on which to gather statistics. The integer value for the autorefresh interval (in milliseconds) is the same value that was originally specified when the autorefresh cache group was created to indicate how often autorefresh is scheduled.
`isStatic`	`TT_INTEGER`	Indicates if you are to retrieve information on static or dynamic cache groups with the interval value: `0` - dynamic cache groups `1` - static (non-dynamic) cache groups The default is static.

autoRefInterval

TT_BIGINT NOT NULL

The autorefreshInterval designates the cache group (the one with this autorefresh interval value) on which to gather statistics.

The integer value for the autorefresh interval (in milliseconds) is the same value that was originally specified when the autorefresh cache group was created to indicate how often autorefresh is scheduled.

isStatic

TT_INTEGER

Indicates if you are to retrieve information on static or dynamic cache groups with the interval value:

0 - dynamic cache groups

1 - static (non-dynamic) cache groups

The default is static.

Result Set

ttCacheAutorefIntervalStatsGet returns statistical information about the last 10 autorefresh cycles for a particular autorefresh interval:

Column	Type	Description
`autorefInterval`	`TT_BIGINT`	Autorefresh interval in milliseconds.
`isStatic`	`TT_INTEGER`	Indicates that the information is for static or dynamic cache groups with the interval value: `0` - dynamic cache groups `1` - static (non-dynamic) cache groups
`autorefNumber`	`TT_BIGINT`	Autorefresh number.
`startTimestamp`	`TT_TIMESTAMP`	Autorefresh start time.
`selectLimit`	`TT_BIGINT`	Select row limit set for incremental autorefresh cache group.
`numRows`	`TT_BIGINT`	Number of rows refreshed.
`numOps`	`TT_BIGINT`	Number of SQL operations in process.
`numCommits`	`TT_BIGINT`	Number of commits.
`commitBufSize`	`TT_BIGINT`	Maximum commit buffer size in bytes.
`commitBufMaxReached`	`TT_BIGINT`	Amount of memory used for commit processing in bytes.
`commitBufNumOverflows`	`TT_BIGINT`	Number of times the commit buffer overflowed for each transaction.
`totalNumRows`	`TT_BIGINT`	Number of rows refreshed since the autorefresh thread was started.
`totalNumOps`	`TT_BIGINT`	Number of SQL operations were performed since the autorefresh thread was started.
`totalNumCommits`	`TT_BIGINT`	Number of commits since the autorefresh thread was started.
`totalNumRollbacks`	`TT_BIGINT`	Number of `s` since the autorefresh thread started
`totalNumSnapshotOld`	`TT_BIGINT`	Number of "Snapshot too old" errors received since the autorefresh thread started

Examples

The following example shows how to run ttCacheAutorefIntervalStatsGet built-in procedure to retrieve statistics for autorefresh cache groups that have been defined as static and have the interval of seven seconds:

Command> call ttCacheAutorefIntervalStatsGet(7000,1);

< 7000, 1, 41, 2013-04-25 15:17:00.000000, 0, 0, 0, 1, 0, 0, <NULL>, 
132121, 132121, 13, 21, 0, 0, 0, 0 >
< 7000, 1, 40, 2013-04-25 15:16:53.000000, 0, 0, 0, 1, 0, 0, <NULL>, 
132121, 132121, 12, 21, 0, 0, 0, 0 >
< 7000, 1, 39, 2013-04-25 15:16:46.000000, 0, 0, 0, 1, 0, 0, <NULL>, 
132121, 132121, 11, 21, 0, 0, 0, 0 >
< 7000, 1, 38, 2013-04-25 15:16:39.000000, 0, 0, 0, 1, 0, 0, <NULL>, 
132121, 132121, 10, 21, 0, 0, 0, 0 >
< 7000, 1, 37, 2013-04-25 15:16:32.000000, 0, 6305, 6305, 1, 0, 131072, 
<NULL>, 132121, 132121, 9, 21, 0, 0, 0, 0 >
< 7000, 1, 36, 2013-04-25 15:16:24.000000, 0, 15616, 15616, 1, 0, 131072, 
<NULL>, 125816, 125816, 8, 21, 0, 0, 0, 0 >
< 7000, 1, 35, 2013-04-25 15:16:17.000000, 0, 18176, 18176, 1, 0, 131072, 
<NULL>, 110200, 110200, 7, 21, 0, 0, 0, 0 >
< 7000, 1, 34, 2013-04-25 15:16:10.000000, 0, 14336, 14336, 1, 0, 131072, 
<NULL>, 92024, 92024, 6, 21, 0, 0, 0, 0 >
< 7000, 1, 33, 2013-04-25 15:16:03.000000, 0, 15360, 15360, 1, 0, 131072, 
<NULL>, 77688, 77688, 5, 21, 0, 0, 0, 0 >
< 7000, 1, 32, 2013-04-25 15:15:56.000000, 0, 11520, 11520, 1, 0, 131072, 
<NULL>, 62328, 62328, 4, 21, 0, 0, 0, 0 >

10 rows found.

This procedure is available only for cache operations.