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