SAP ORAEXPLPAR table - Parameter for Explain from v$sql_plan details in SAP
SAP ORAEXPLPAR table summary
Object Name: ORAEXPLPAR
Dictionary Type: Structure
Description: Parameter for Explain from v$sql_plan
Field list for ORAEXPLPAR table on an S/4 SAP system
| Details |
ORAEXPLPAR-ADDRESS table field - Address of statement in the cache
▼
Description: Address of statement in the cache
Field Name: ADDRESS
Data Element: ORAADDRESS
Data Type: CHAR
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: CHAR16
MemoryID:
AppClass: SLG
SHLP:
SHLP Field:
ConvExit:
See all SAP tables containing field ADDRESS
|
ORAEXPLPAR-HASH_VALUE table field - Hash value of statement
▼
Description: Hash value of statement
Field Name: HASH_VALUE
Data Element: ORAHASHVAL
Data Type: FLTP
length (Dec): 16(16)
Check table:
Conversion Routine:
Domain Name: ORAP16
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:
See all SAP tables containing field HASH_VALUE
|
ORAEXPLPAR-CHILD_NUMBER table field - Child Cursor Number
▼
Description: Child Cursor Number
Field Name: CHILD_NUMBER
Data Element: ORACHILDNUM
Data Type: FLTP
length (Dec): 16(16)
Check table:
Conversion Routine:
Domain Name: ORAP16
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:
See all SAP tables containing field CHILD_NUMBER
|
ORAEXPLPAR-CON_NAME table field - Logical name of a database connection
▼
Description: Logical name of a database connection
Field Name: CON_NAME
Data Element: DBCON_NAME
Data Type: CHAR
length (Dec): 30(0)
Check table: *
Conversion Routine:
Domain Name: DBCON_NAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:
See all SAP tables containing field CON_NAME
|
ORAEXPLPAR-FLAGS table field - Field Name
▼
Description: Field Name
Field Name: FLAGS
Data Element: FIELDNAME
Data Type: CHAR
length (Dec): 30(0)
Check table: *
Conversion Routine:
Domain Name: FDNAME
MemoryID: DFD
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:
See all SAP tables containing field FLAGS
|
ORAEXPLPAR-INST_ID table field - Oracle Instance ID
▼
Description: Oracle Instance ID
Field Name: INST_ID
Data Element: ORAINST_ID
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: ORANUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:
See all SAP tables containing field INST_ID
|
ORAEXPLPAR-ASHEVENT table field - Event
▼
Description: Event
Field Name: ASHEVENT
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:
See all SAP tables containing field ASHEVENT
|
ORAEXPLPAR-ASH_SOURCE table field - v$active_session_history <-> DBA_HIST_ACTIVE_SESS_HISTORY
▼
Description: v$active_session_history <-> DBA_HIST_ACTIVE_SESS_HISTORY
Field Name: ASH_SOURCE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:
See all SAP tables containing field ASH_SOURCE
|
ORAEXPLPAR-SQL_ID table field - sql_id
▼
Description: sql_id
Field Name: SQL_ID
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:
See all SAP tables containing field SQL_ID
|
ORAEXPLPAR-HIST_BEGIN_TS table field - Start of the DBA action
▼
Description: Start of the DBA action
Field Name: HIST_BEGIN_TS
Data Element: SDBA_BEGIN
Data Type: CHAR
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: SDBA_TSTMP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:
See all SAP tables containing field HIST_BEGIN_TS
|
ORAEXPLPAR-HIST_END_TS table field - Start of the DBA action
▼
Description: Start of the DBA action
Field Name: HIST_END_TS
Data Element: SDBA_BEGIN
Data Type: CHAR
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: SDBA_TSTMP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:
See all SAP tables containing field HIST_END_TS
|
ORAEXPLPAR-PLAN_HASH_VALUE table field -
▼
Description:
Field Name: PLAN_HASH_VALUE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:
See all SAP tables containing field PLAN_HASH_VALUE
|
View list of all SAP tables(S4H/ECC)Select data from SAP table
