SAP ABAP Table ORABLKANAL (Detailed Analysis of Oracle Tables)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-CCM-MON-TUN (Application Component) Performance Monitors (TCC)
⤷
STUN (Package) DBA: All the rest in English
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-CCM-MON-TUN (Application Component) Performance Monitors (TCC)⤷
STUN (Package) DBA: All the rest in English
Basic Data
| Table Category | INTTAB | Structure |
| Structure | ORABLKANAL |
Table Relationship Diagram 
|
| Short Description | Detailed Analysis of Oracle Tables |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | ||
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
 |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  A_SIZE |
OA_SIZE | DEC15 | DEC | 15 | 0 | Allocated diskspace for an Oracle table | ||
| 2 | A_BLOCKS |
OA_BLOCKS | DEC11 | DEC | 11 | 0 | Allocated blocks for an Oracle table | ||
| 3 | A_EXTENTS |
OA_EXTENTS | INT4 | INT4 | 10 | 0 | Allocated extents for an Oracle table | ||
| 4 | U_SIZE |
OU_SIZE | DEC15 | DEC | 15 | 0 | Disk space used for Oracle table | ||
| 5 | U_BLOCKS |
OU_BLOCKS | DEC11 | DEC | 11 | 0 | Used blocks of an Oracle table | ||
| 6 | E_SIZE |
OE_SIZE | DEC15 | DEC | 15 | 0 | Empty space allocated for an Oracle table | ||
| 7 | E_BLOCKS |
OE_BLOCKS | DEC11 | DEC | 11 | 0 | Empty blocks allocated for an Oracle table | ||
| 8 | INIT_EXT |
OINIT_EXT | DEC15 | DEC | 15 | 0 | Size of initial table extent | ||
| 9 | NEXT_EXT |
ONEXT_EXT | DEC15 | DEC | 15 | 0 | Size of next extent | ||
| 10 | MIN_EXTS |
OMIN_EXTS | INT4 | INT4 | 10 | 0 | Oracle storage parameter 'minextents' | ||
| 11 | MAX_EXTS |
OMAX_EXTS | INT4 | INT4 | 10 | 0 | Oracle storage parameter 'maxextents' | ||
| 12 | PCTINCR |
OPCTINCR | INT2 | INT2 | 5 | 0 | Storage parameter 'pctincrease' | ||
| 13 | BLKSIZE |
OBLKSIZE | INT4 | INT4 | 10 | 0 | Oracle block size | ||
| 14 | AVG_BFREE |
OAVG_BFREE | INT4 | INT4 | 10 | 0 | Avg. freespace in a used data base block | ||
| 15 | PCT_FREE |
OPCT_FREE | INT2 | INT2 | 5 | 0 | Oracle storage parameter 'PCTFREE' | ||
| 16 | P_PCT_FREE |
OP_PCT_FRE | INT2 | INT2 | 5 | 0 | Recommended value for storage parameter 'PCTFREE' | ||
| 17 | PCT_USED |
OPCT_USED | INT2 | INT2 | 5 | 0 | Storage parameter 'PCTUSED' | ||
| 18 | P_PCT_USED |
OP_PCT_USE | INT2 | INT2 | 5 | 0 | Recommended value for storage parameter 'PCTUSED' | ||
| 19 | INI_TRANS |
OINI_TRANS | INT2 | INT2 | 5 | 0 | Number of initial transactions (Oracle storage parameter) | ||
| 20 | MAX_TRANS |
OMAX_TRANS | INT2 | INT2 | 5 | 0 | Maximum number of transactions (Oracle storage parameter) | ||
| 21 | HEADER_MIN |
OHEADER_MI | INT4 | INT4 | 10 | 0 | Block header, minimum size | ||
| 22 | HEADER_MAX |
OHEADER_MA | INT4 | INT4 | 10 | 0 | Block header, maximum size | ||
| 23 | DATA_MIN |
ODATA_MIN | INT4 | INT4 | 10 | 0 | Minimum size of the data area in a block | ||
| 24 | DATA_MAX |
ODATA_MAX | INT4 | INT4 | 10 | 0 | Maximum size of the data area in a block | ||
| 25 | ROWS |
OROWS | DEC15 | DEC | 15 | 0 | Number of rows in a table | ||
| 26 | CHAINED |
OCHAINED | DEC15 | DEC | 15 | 0 | Number of rows requiring block chaining | ||
| 27 | AVG_ROW_EH |
OAVG_ROW_E | DEC11 | DEC | 11 | 0 | Average row length without block header | ||
| 28 | AVG_ROW_IH |
OAVG_ROW_I | DEC11 | DEC | 11 | 0 | Avg. row length including the block header | ||
| 29 | AVG_RO_IHR |
OAVG_RO_IH | DEC11 | DEC | 11 | 0 | Avg. row length to take into account for initial loading |
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in |
