ttStatsConfigGet

The ttStatsConfigGet built-in procedure returns parameters of the ttStats utility that you can set with the ttStatsConfig built-in procedure. This procedure does not take any input and outputs a multiple row result set with name/value pair parameters.

Required Privilege

This procedure requires no privilege.

Usage in TimesTen Scaleout and TimesTen Classic

This procedure is supported in TimesTen Classic.

This procedure is supported in TimesTen Scaleout, but supports different parameter/value pairs than in TimesTen Classic.

In TimesTen Scaleout, this procedure returns a row for the element from which it was called. To see information about other elements, query the SYS.GV$STATS_CONFIG system table.

Related Views

This procedure has these related views.

SYS.GV$STATS_CONFIG

SYS.V$STATS_CONFIG

Syntax

ttStatsConfigGet()

Parameters

ttStatsConfigGet has no parameters:

Result Set

ttStatsConfigGet returns the result set:

Column	Type	Description
`param`	`VARCHAR2(50)`	The name of the parameter.
`value`	`VARCHAR2(200)`	The current value of the parameter.

Parameter / Value Pairs

The supported return parameter/value pairs in TimesTen and TimesTen Scaleout are different. These are the return parameter/value pairs:

TimesTen Classic

These parameter/value pairs can be returned in the result set in TimesTen Classic:

Parameter	Description
`SQLCmdSampleFactor`	The frequency at which a SQL command sample is taken. The default is `0`. A value of `0` indicates that sampling is turned off. A value greater than `0` indicates that a sample is taken at that interval of SQL statements. For example, a value of `10` indicates that for every 10th SQL statement run, the wall clock time of that run is captured.
`ConnSampleFactor`	The unique identifier of a SQL command in the TimesTen command cache. If you do not supply a value, TimesTen displays the current value of the command.
`StatsLevel`	The existing SQL run time statistics are reset if the specified value is nonzero.

TimesTen Scaleout

These parameter/value pairs can be returned in the result set in TimesTen Scaleout:

Parameter	Description
`pollSec`	The polling interval, in seconds, at which the `ttStats` daemon captures snapshots of the TimesTen Scaleout. A value of `0` disables the `ttStats` daemon from capturing metrics.
`retainMinutes`	The time, in minutes, that the `ttStats` daemon waits before aggregating and purging raw metrics.
`retentionDays`	The retention time interval, in days, at which the `ttStats` daemon drops `ttStats` snapshots of the TimesTen Scaleout. For example, if the retention time interval is 62 days, the `ttStats` daemon drops the 1st day's snapshot on the 63rd day.

Examples

Since TimesTen and TimesTen Scaleout support different name/value pair results, there are also different examples. These are supported examples:

TimesTen Classic

View the configuration settings of ttStatsConfig:

Command> call ttStatsConfigGet();
< SQLCMDSAMPLEFACTOR, 1 >
< CONNSAMPLEFACTOR, 2047,0 >
< STATSLEVEL, TYPICAL >
3 rows found.

TimesTen Scaleout

View the configuration settings of ttStatsConfig:

Command> call ttStatsConfigGet();
< POLLSEC, 10 >
< RETAINMINUTES, 120 >
< RETENTIONDAYS, 62 >
3 rows found.