ttStatsConfigGet
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.
Syntax
ttStatsConfigGet()
Parameters
ttStatsConfigGet
has no parameters:
Result Set
ttStatsConfigGet
returns the result set:
Column | Type | Description |
---|---|---|
|
|
The name of the parameter. |
|
|
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 |
---|---|
|
The frequency at which a SQL command sample is taken. The default is |
|
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. |
|
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 |
---|---|
|
The polling interval, in seconds, at which the |
|
The time, in minutes, that the |
|
The retention time interval, in days, at which the |
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.
See Also