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) |
|
|
|
|