| TNAME |
X |
TNAME |
CHAR |
0 |
30 |
0 |
|
Table name |
| ANDAT |
X |
AM_ANDAT |
DATS |
30 |
8 |
0 |
|
Analysis date for application monitor |
| ACTIV |
|
AM_ACTIVS |
CHAR |
38 |
2 |
0 |
|
Activation flag Application monitor |
| AMETH |
|
AM_AMETH |
CHAR |
40 |
4 |
0 |
|
Analysis Method for Collecting Statistics |
| OPTIO |
|
AM_OPTIO |
CHAR |
44 |
5 |
0 |
|
Sample Size for Collection of Statistics |
| NROWS |
|
OROWS |
DEC |
49 |
15 |
0 |
|
Number of rows in a table |
| OCCBL |
|
OU_BLOCKS |
DEC |
57 |
11 |
0 |
|
Used blocks of an Oracle table |
| EMPBL |
|
OE_BLOCKS |
DEC |
63 |
11 |
0 |
|
Empty blocks allocated for an Oracle table |
| AFREE |
|
OAVG_BFREE |
INT4 |
72 |
10 |
0 |
|
Avg. freespace in a used data base block |
| CHAIN |
|
OCHAINED |
DEC |
76 |
15 |
0 |
|
Number of rows requiring block chaining |
| AROWL |
|
OAVG_ROW_L |
DEC |
84 |
7 |
0 |
|
Average row length (Oracle result) |
| INDBL |
|
OIND_ALLBL |
DEC |
88 |
11 |
0 |
|
Allocated blocks for an Oracle index |
| INDBS |
|
OBTREE_SPC |
DEC |
94 |
15 |
0 |
|
Total space allocated in the B tree (ORACLE) |
| INDUS |
|
OBTREE_USE |
DEC |
102 |
15 |
0 |
|
Total space used in B tree (ORACLE) |