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.

Related Views

This procedure has this related view.

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