Data Element list used by SAP ABAP Table ORABLKANAL (Detailed Analysis of Oracle Tables)
SAP ABAP Table
ORABLKANAL (Detailed Analysis of Oracle Tables) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | OAVG_BFREE | Avg. freespace in a used data base block | ||
| 2 | OAVG_ROW_E | Average row length without block header | ||
| 3 | OAVG_ROW_I | Avg. row length including the block header | ||
| 4 | OAVG_RO_IH | Avg. row length to take into account for initial loading | ||
| 5 | OA_BLOCKS | Allocated blocks for an Oracle table | ||
| 6 | OA_EXTENTS | Allocated extents for an Oracle table | ||
| 7 | OA_SIZE | Allocated diskspace for an Oracle table | ||
| 8 | OBLKSIZE | Oracle block size | ||
| 9 | OCHAINED | Number of rows requiring block chaining | ||
| 10 | ODATA_MAX | Maximum size of the data area in a block | ||
| 11 | ODATA_MIN | Minimum size of the data area in a block | ||
| 12 | OE_BLOCKS | Empty blocks allocated for an Oracle table | ||
| 13 | OE_SIZE | Empty space allocated for an Oracle table | ||
| 14 | OHEADER_MA | Block header, maximum size | ||
| 15 | OHEADER_MI | Block header, minimum size | ||
| 16 | OINIT_EXT | Size of initial table extent | ||
| 17 | OINI_TRANS | Number of initial transactions (Oracle storage parameter) | ||
| 18 | OMAX_EXTS | Oracle storage parameter 'maxextents' | ||
| 19 | OMAX_TRANS | Maximum number of transactions (Oracle storage parameter) | ||
| 20 | OMIN_EXTS | Oracle storage parameter 'minextents' | ||
| 21 | ONEXT_EXT | Size of next extent | ||
| 22 | OPCTINCR | Storage parameter 'pctincrease' | ||
| 23 | OPCT_FREE | Oracle storage parameter 'PCTFREE' | ||
| 24 | OPCT_USED | Storage parameter 'PCTUSED' | ||
| 25 | OP_PCT_FRE | Recommended value for storage parameter 'PCTFREE' | ||
| 26 | OP_PCT_USE | Recommended value for storage parameter 'PCTUSED' | ||
| 27 | OROWS | Number of rows in a table | ||
| 28 | OU_BLOCKS | Used blocks of an Oracle table | ||
| 29 | OU_SIZE | Disk space used for Oracle table |