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' |