SAP ORA_S_AWR_SEL_SQLID table - Oracle monitoring: Select structure for history snapshots details in SAP


SAP ORA_S_AWR_SEL_SQLID table summary

Object Name: ORA_S_AWR_SEL_SQLID
Dictionary Type: Structure
Description: Oracle monitoring: Select structure for history snapshots


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

Details
ORA_S_AWR_SEL_SQLID-SQLID table field - Oracle monitoring: SQL_ID

Description: Oracle monitoring: SQL_ID
Field Name: SQLID
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 SQLID

ORA_S_AWR_SEL_SQLID-SQLTEXT table field - Start of SQL statement

Description: Start of SQL statement
Field Name: SQLTEXT
Data Element: ORASQLTEXT
Data Type: CHAR
length (Dec): 60(0)
Check table:
Conversion Routine:
Domain Name: CHAR60
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLTEXT

ORA_S_AWR_SEL_SQLID-CPU_TIME table field - Oracle Monitoring: CPU_TIME

Description: Oracle Monitoring: CPU_TIME
Field Name: CPU_TIME
Data Element: ORA_CPU_TIME
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CPU_TIME

ORA_S_AWR_SEL_SQLID-EXECUTIONS table field - Oracle Monitoring: EXECUTIONS: # Executions

Description: Oracle Monitoring: EXECUTIONS: # Executions
Field Name: EXECUTIONS
Data Element: ORA_EXECUTIONS
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXECUTIONS

ORA_S_AWR_SEL_SQLID-ELAPSED_TIME table field - Oracle Monitoring: ELAPSED_TIME: in microseconds

Description: Oracle Monitoring: ELAPSED_TIME: in microseconds
Field Name: ELAPSED_TIME
Data Element: ORA_ELAPSED_TIME
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ELAPSED_TIME

ORA_S_AWR_SEL_SQLID-LAST_LOAD_TIME table field - Oracle Monitoring: LAST_LOAD_TIME

Description: Oracle Monitoring: LAST_LOAD_TIME
Field Name: LAST_LOAD_TIME
Data Element: ORA_LAST_LOAD_TIME
Data Type: CHAR
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_19
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LAST_LOAD_TIME


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table