SAP ORA_S_SQL_MONITORING_EXECPLAN table - SQL Monitoring: Execution plan details in SAP

SAP ORA_S_SQL_MONITORING_EXECPLAN table summary

Object Name: ORA_S_SQL_MONITORING_EXECPLAN
Dictionary Type: Structure
Description: SQL Monitoring: Execution plan

Field list for ORA_S_SQL_MONITORING_EXECPLAN table on an S/4 SAP system

Details

ORA_S_SQL_MONITORING_EXECPLAN-PLAN_ID table field - SQL plan line ID ▼

Description: SQL plan line ID
Field Name: PLAN_ID
Data Element: ORA_SQL_PLAN_LINE_ID
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_ID

ORA_S_SQL_MONITORING_EXECPLAN-ACTION_INFO table field - Plan operation name with 64 Char ▼

Description: Plan operation name with 64 Char
Field Name: ACTION_INFO
Data Element: ORA_SQL_PLAN_OPERATION64
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ACTION_INFO

ORA_S_SQL_MONITORING_EXECPLAN-STARTS table field - Oracle: Number of times this operation was executed ▼

Description: Oracle: Number of times this operation was executed
Field Name: STARTS
Data Element: ORA_SQL_STARTS
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_DEC_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STARTS

ORA_S_SQL_MONITORING_EXECPLAN-RECORDS table field - Number of rows produced operation since exec start ▼

Description: Number of rows produced operation since exec start
Field Name: RECORDS
Data Element: ORA_RECORDS
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_DEC_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RECORDS

ORA_S_SQL_MONITORING_EXECPLAN-PLAN_CARDINALITY table field - Optimizer estimate: number of rows produced by the operation ▼

Description: Optimizer estimate: number of rows produced by the operation
Field Name: PLAN_CARDINALITY
Data Element: ORA_PLAN_CARDINALITY
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_CARDINALITY

ORA_S_SQL_MONITORING_EXECPLAN-IO_READ_MB table field - Oracle_ Physical Reads ▼

Description: Oracle_ Physical Reads
Field Name: IO_READ_MB
Data Element: ORA_PHYS_READ_MB
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_DEC_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field IO_READ_MB

ORA_S_SQL_MONITORING_EXECPLAN-WA_TEMP_MB table field - Oracle: Temporary space used during query execution ▼

Description: Oracle: Temporary space used during query execution
Field Name: WA_TEMP_MB
Data Element: ORA_WA_TMP_SEG
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_DEC_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WA_TEMP_MB

ORA_S_SQL_MONITORING_EXECPLAN-INST_ID table field - Oracle monitoring: Instance ID ▼

Description: Oracle monitoring: Instance ID
Field Name: INST_ID
Data Element: ORA_INST_C
Data Type: CHAR
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_INST_C
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INST_ID

ORA_S_SQL_MONITORING_EXECPLAN-SID table field - Oracle Monitoring: SID: SID for which param is defined ▼

Description: Oracle Monitoring: SID: SID for which param is defined
Field Name: SID
Data Element: ORA_PARAM_SID
Data Type: CHAR
length (Dec): 80(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_80
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SID

ORA_S_SQL_MONITORING_EXECPLAN-SQL_ID table field - Oracle monitoring: SQL_ID ▼

Description: Oracle monitoring: SQL_ID
Field Name: SQL_ID
Data Element: ORA_SQL_ID
Data Type: CHAR
length (Dec): 13(0)
Check table:
Conversion Routine:
Domain Name: ORA_SQLID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQL_ID

ORA_S_SQL_MONITORING_EXECPLAN-SQL_EXEC_ID table field - SQL execution identifier ▼

Description: SQL execution identifier
Field Name: SQL_EXEC_ID
Data Element: ORA_SQL_EXEC_ID
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_EXEC_ID

ORA_S_SQL_MONITORING_EXECPLAN-START_TIME table field - SQL Monitoring: SQL Execution start ▼

Description: SQL Monitoring: SQL Execution start
Field Name: START_TIME
Data Element: ORA_SQLM_TIMESTAMP
Data Type: CHAR
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: CHAR22
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field START_TIME

ORA_S_SQL_MONITORING_EXECPLAN-ELAPSED_S table field - SQL Monitoring: Elapsed time in [s] ▼

Description: SQL Monitoring: Elapsed time in [s]
Field Name: ELAPSED_S
Data Element: ORA_ELAPSED_S
Data Type: CHAR
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ELAPSED_S

ORA_S_SQL_MONITORING_EXECPLAN-STATUS table field - SQL Monitoring: Status ▼

Description: SQL Monitoring: Status
Field Name: STATUS
Data Element: ORA_SQLMON_STATUS
Data Type: CHAR
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: CHAR19
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STATUS

View list of all SAP tables(S4H/ECC)

Select data from SAP table