STATTAB FIELD DESCRIPTION (DBMS_STATS)

COLUMN	DATA TYPE	TYPE=’T’	TYPE=’C’	TYPE=’I’	TYPE=’S’(Oracle 9i)
STATID	VARCHAR2(30)	User settable	User settable	User settable	User settable
TYPE	CHAR(1)	Table	Column	Index	System
VERSION	NUMBER
FLAGS	NUMBER
C1	VARCHAR2(30)	Table name	Table name	Index name	Status
C2	VARCHAR2(30)	Partition name	Partition name	Partition name	Dstart
C3	VARCHAR2(30)	Subpartition name	Subpartition name	Subpartition name	Dstop
C4	VARCHAR2(30)		Column name		‘CPU_SERIO’/’PARIO’
C5	VARCHAR2(30)	Owner	Owner	Owner	Owner
N1	NUMBER	Num rows	Num distinct	Num rows	Sreadtim/maxthr
N2	NUMBER	Blocks	Density	Leaf blocks	Mreadtim/slavethr
N3	NUMBER	Average row length		Distinct keys	CPU speed/
N4	NUMBER	Sample size	Sample size	Leaf blocks/key
N5	NUMBER		Num nulls	Data blocks/key
N6	NUMBER		Lower value	Clustering factor
N7	NUMBER		High value	Blevel
N8	NUMBER		Average column length	Sample size
N9	NUMBER		?(always 1)
N10	NUMBER		Endpoint number
N11	NUMBER		Endpoint value		Mbrc/
N12	NUMBER		?(always null)
D1	DATE	Last analyzed	Last analyzed	Last analyzed	Last analyzed
R1	RAW(32)
R2	RAW(32)
CH1	VARCHAR2(1000)