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

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

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

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

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

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

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

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

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

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

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

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

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

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

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