Data Element list used by SAP ABAP Table ORAINDANAL (Detailed Analysis of Oracle Indexes (fr. V.7))
SAP ABAP Table ORAINDANAL (Detailed Analysis of Oracle Indexes (fr. V.7)) is using
# Object Type Object Name Object Description Note
     
1 Data Element  OA_BLOCKS Allocated blocks for an Oracle table
2 Data Element  OA_EXTENTS Allocated extents for an Oracle table
3 Data Element  OA_SIZE Allocated diskspace for an Oracle table
4 Data Element  OBLEVEL Depth of the index from its root block to its leaf blocks
5 Data Element  OBLKSIZE Oracle block size
6 Data Element  OCLU_FACTO Amount of order of table rows based on index values
7 Data Element  ODATA_MAX Maximum size of the data area in a block
8 Data Element  ODATA_MIN Minimum size of the data area in a block
9 Data Element  ODBLKS_P_K Avg. data blocks per value of index
10 Data Element  ODIST_KEYS Number of distinct indexed values
11 Data Element  OHEADER_MA Block header, maximum size
12 Data Element  OHEADER_MI Block header, minimum size
13 Data Element  OINIT_EXT Size of initial table extent
14 Data Element  OINI_TRANS Number of initial transactions (Oracle storage parameter)
15 Data Element  OLBLKS_P_K Avg. leaf blks per value of index key
16 Data Element  OLEAF_BLKS Number of leaf blocks in the index
17 Data Element  OMAX_EXTS Oracle storage parameter 'maxextents'
18 Data Element  OMAX_TRANS Maximum number of transactions (Oracle storage parameter)
19 Data Element  OMIN_EXTS Oracle storage parameter 'minextents'
20 Data Element  ONEXT_EXT Size of next extent
21 Data Element  OPCTINCR Storage parameter 'pctincrease'
22 Data Element  OPCT_FREE Oracle storage parameter 'PCTFREE'
23 Data Element  OPCT_USED Storage parameter 'PCTUSED'
24 Data Element  OP_PCT_FRE Recommended value for storage parameter 'PCTFREE'
25 Data Element  OP_PCT_USE Recommended value for storage parameter 'PCTUSED'