SAP table ORAEXPLPAR (Parameter for Explain from v$sql_plan)
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| ADDRESS | Address of statement in the cache | CHAR | 16 | 0 | ORAADDRESS | ||
| HASH_VALUE | Hash value of statement | FLTP | 16 | 16 | ORAHASHVAL | ||
| CHILD_NUMBER | Child Cursor Number | FLTP | 16 | 16 | ORACHILDNUM | ||
| CON_NAME | Logical name of a database connection | CHAR | 30 | 0 | * | DBCON_NAME | |
| FLAGS | Field Name | CHAR | 30 | 0 | * | FIELDNAME | |
| INST_ID | Oracle Instance ID | INT4 | 10 | 0 | ORAINST_ID | ||
| ASHEVENT | CHAR | 64 | 0 | ||||
| ASH_SOURCE | CHAR | 30 | 0 | ||||
| SQL_ID | CHAR | 13 | 0 | ||||
| HIST_BEGIN_TS | Start of the DBA action | CHAR | 14 | 0 | SDBA_BEGIN | ||
| HIST_END_TS | Start of the DBA action | CHAR | 14 | 0 | SDBA_BEGIN | ||
| PLAN_HASH_VALUE | CHAR | 30 | 0 |