ORAINDINFO - Information About the Storage Quality of the Indexes

Information About the Storage Quality of the Indexes information is stored in SAP table ORAINDINFO.
It is part of development package S_DBMON_ORA in software component BC-CCM-MON-ORA. This development package consists of objects that can be grouped under "Database Monitor for Oracle".

Fields for table ORAINDINFO

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
STARTKEYTime Stamp of the Start of the Operation for the IndexXNUMC14
IND_NAMEIndex NameXCHAR30
OPERATIONStart Mode of the Report RSORAISQ (Analysis or Rebuild)CHAR3
SCHEDULEDScheduled, Operation not Started or not FinishedCHAR1
ENDKEYTime Stamp of the End of the Operation for the IndexNUMC14
TABLE_NAMEName of the Indexed ObjectCHAR30
QUALITYCalculated Storage Quality for the IndexDEC6
TOTAL_BYTEIndex SizeDEC6
DURATIONDuration of the Operation (Analysis or Rebuild)DEC6
IND_OWNEROwner of the IndexCHAR30
INDEX_TYPEType of Index (NORMAL, BITMAP, FUNC-BASED, BITMAP or DOMAIN)CHAR10
TABSPACEIndex Tablespace NameCHAR30
INI_TRANSInitial Number of TransactionsDEC6
PCT_FREEMinimum Percentage of Free Space in a BlockDEC6
FREEL_GRPSNumber of Freelist Groups Allocated to this SegmentDEC6
FREEL_BLKSFreelist Blocks Based on dbms_space.free_blocksDEC6
NUM_ROWSNumber of Rows in the TableDEC6
AV_DAT_SPCCalculated Average Space per RowDEC6
TOTAL_BLKSTotal Index Blocks Based on dbms_space-unused_spaceDEC6
USED_BLKSUsed Index Blocks Based on dbms_space.unused_spaceDEC6
UNUSD_BLKSUnused Index Blocks Based on dbms_space-unused_spaceDEC6
UNUSD_BYTEUnused Bytes of Index Based on dbms_space-unused_spaceDEC6
COLHEADLENEstimated Bytes for Row Header per Index EntryDEC6
TOTENTRLENEstimated Total Bytes per Index EntryDEC6
NUMOF_BLKSEstimated Number of Blocks Needed when Creating the IndexDEC6
SUM_COLSSum of Average Size for All Columns of the IndexDEC6
Privacy Policy