ttOptGetColStats

This procedure returns statistics information in text format.

See ttOptSetColIntvlStats for the layout of the statistics.

Required Privilege

This procedure requires the SELECT privilege on the specified tables.

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.

SYS.GV$OPT_COL_STATS

SYS.V$OPT_COL_STATS

Syntax

ttOptGetColStats('tblName', 'colName')

Parameters

ttOptGetColStats has these parameters:

Parameter	Type	Description
tblName	TT_CHAR (61)	Name of the table whose statistics are to be returned. If NULL is passed, then values for all tables are returned. Using a synonym to specify a table name is not supported.
colName	TT_CHAR (30)	Name of the column for which statistics should be returned. If NULL is passed, statistics for all columns in the specified table are returned.

Result Set

ttOptGetColStats returns the result set:

Column	Type	Description
tblName	TT_CHAR (30)	Name of the table. Using a synonym to specify a table name is not supported.
colName	TT_CHAR (30)	Name of the column.
stats	TT_VARCHAR (409600) NOT NULL	Statistics in text form.

Examples

CALL ttOptGetColStats ();
< T1 , X1, (2, 10, 10, 100 (,4, 40, 10 ,1, 10, 5) ,
(4, 20, 20 ,11, 20, 15) )>

See Also

• ttOptSetColStats
• ttOptSetColIntvlStats