STARTKEY | Time Stamp of the Start of the Operation for the Index | X | | NUMC | 14 | |
IND_NAME | Index Name | X | | CHAR | 30 | |
OPERATION | Start Mode of the Report RSORAISQ (Analysis or Rebuild) | | | CHAR | 3 | |
SCHEDULED | Scheduled, Operation not Started or not Finished | | | CHAR | 1 | |
ENDKEY | Time Stamp of the End of the Operation for the Index | | | NUMC | 14 | |
TABLE_NAME | Name of the Indexed Object | | | CHAR | 30 | |
QUALITY | Calculated Storage Quality for the Index | | | DEC | 6 | |
TOTAL_BYTE | Index Size | | | DEC | 6 | |
DURATION | Duration of the Operation (Analysis or Rebuild) | | | DEC | 6 | |
IND_OWNER | Owner of the Index | | | CHAR | 30 | |
INDEX_TYPE | Type of Index (NORMAL, BITMAP, FUNC-BASED, BITMAP or DOMAIN) | | | CHAR | 10 | |
TABSPACE | Index Tablespace Name | | | CHAR | 30 | |
INI_TRANS | Initial Number of Transactions | | | DEC | 6 | |
PCT_FREE | Minimum Percentage of Free Space in a Block | | | DEC | 6 | |
FREEL_GRPS | Number of Freelist Groups Allocated to this Segment | | | DEC | 6 | |
FREEL_BLKS | Freelist Blocks Based on dbms_space.free_blocks | | | DEC | 6 | |
NUM_ROWS | Number of Rows in the Table | | | DEC | 6 | |
AV_DAT_SPC | Calculated Average Space per Row | | | DEC | 6 | |
TOTAL_BLKS | Total Index Blocks Based on dbms_space-unused_space | | | DEC | 6 | |
USED_BLKS | Used Index Blocks Based on dbms_space.unused_space | | | DEC | 6 | |
UNUSD_BLKS | Unused Index Blocks Based on dbms_space-unused_space | | | DEC | 6 | |
UNUSD_BYTE | Unused Bytes of Index Based on dbms_space-unused_space | | | DEC | 6 | |
COLHEADLEN | Estimated Bytes for Row Header per Index Entry | | | DEC | 6 | |
TOTENTRLEN | Estimated Total Bytes per Index Entry | | | DEC | 6 | |
NUMOF_BLKS | Estimated Number of Blocks Needed when Creating the Index | | | DEC | 6 | |
SUM_COLS | Sum of Average Size for All Columns of the Index | | | DEC | 6 | |