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.

Related Views

This procedure has this related view.

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

These are the return parameter/value pairs in TimesTen:

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

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.

Examples

These are the supported examples:

View the configuration settings of ttStatsConfig:

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