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 | OA_BLOCKS | Allocated blocks for an Oracle table | ||
| 2 | OA_EXTENTS | Allocated extents for an Oracle table | ||
| 3 | OA_SIZE | Allocated diskspace for an Oracle table | ||
| 4 | OBLEVEL | Depth of the index from its root block to its leaf blocks | ||
| 5 | OBLKSIZE | Oracle block size | ||
| 6 | OCLU_FACTO | Amount of order of table rows based on index values | ||
| 7 | ODATA_MAX | Maximum size of the data area in a block | ||
| 8 | ODATA_MIN | Minimum size of the data area in a block | ||
| 9 | ODBLKS_P_K | Avg. data blocks per value of index | ||
| 10 | ODIST_KEYS | Number of distinct indexed values | ||
| 11 | OHEADER_MA | Block header, maximum size | ||
| 12 | OHEADER_MI | Block header, minimum size | ||
| 13 | OINIT_EXT | Size of initial table extent | ||
| 14 | OINI_TRANS | Number of initial transactions (Oracle storage parameter) | ||
| 15 | OLBLKS_P_K | Avg. leaf blks per value of index key | ||
| 16 | OLEAF_BLKS | Number of leaf blocks in the index | ||
| 17 | OMAX_EXTS | Oracle storage parameter 'maxextents' | ||
| 18 | OMAX_TRANS | Maximum number of transactions (Oracle storage parameter) | ||
| 19 | OMIN_EXTS | Oracle storage parameter 'minextents' | ||
| 20 | ONEXT_EXT | Size of next extent | ||
| 21 | OPCTINCR | Storage parameter 'pctincrease' | ||
| 22 | OPCT_FREE | Oracle storage parameter 'PCTFREE' | ||
| 23 | OPCT_USED | Storage parameter 'PCTUSED' | ||
| 24 | OP_PCT_FRE | Recommended value for storage parameter 'PCTFREE' | ||
| 25 | OP_PCT_USE | Recommended value for storage parameter 'PCTUSED' |