SAP Table ORAEXPLPAR
Parameter for Explain from v$sql_plan
ORAEXPLPAR (Parameter for Explain from v$sql_plan) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link ORAEXPLPAR to other SAP tables.
Source: ORAEXPLPAR (Parameter for Explain from v$sql_plan)
ORAEXPLPAR table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| ADDRESS | Address of statement in the cache | ORAADDRESS | CHAR | 16 | 0 | |||
| HASH_VALUE | Hash value of statement | ORAHASHVAL | FLTP | 16 | 16 | |||
| CHILD_NUMBER | Child Cursor Number | ORACHILDNUM | FLTP | 16 | 16 | |||
| CON_NAME | Logical name for a database connection | DBCON_NAME | CHAR | 30 | 0 | |||
| FLAGS | Field Name | FIELDNAME | CHAR | 30 | 0 | |||
| INST_ID | Oracle Instance ID | ORAINST_ID | INT4 | 10 | 0 | |||
| ASHEVENT | CHAR | 64 | 0 | |||||
| ASH_SOURCE | CHAR | 30 | 0 | |||||
| SQL_ID | CHAR | 13 | 0 | |||||
| HIST_BEGIN_TS | Start of the DBA action | SDBA_BEGIN | CHAR | 14 | 0 | |||
| HIST_END_TS | Start of the DBA action | SDBA_BEGIN | CHAR | 14 | 0 | |||
| PLAN_HASH_VALUE | CHAR | 30 | 0 | |||||
