SAP ORA_AWR_ASH_REPORT table - Oracle monitoring: data for AWR and ASH reports details in SAP

SAP ORA_AWR_ASH_REPORT table summary

Object Name: ORA_AWR_ASH_REPORT
Dictionary Type: Structure
Description: Oracle monitoring: data for AWR and ASH reports

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

Details

ORA_AWR_ASH_REPORT-REMOTE_SYSTEM table field - Logical name of a database connection ▼

Description: Logical name of a database connection
Field Name: REMOTE_SYSTEM
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 REMOTE_SYSTEM

ORA_AWR_ASH_REPORT-DBID table field - Oracle monitoring: database id ▼

Description: Oracle monitoring: database id
Field Name: DBID
Data Element: ORA_DBID
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 DBID

ORA_AWR_ASH_REPORT-DBNAME table field - Oracle monitoring: database name ▼

Description: Oracle monitoring: database name
Field Name: DBNAME
Data Element: ORA_NAME_DB
Data Type: CHAR
length (Dec): 9(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_9
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBNAME

ORA_AWR_ASH_REPORT-DBREL table field - Technically used: Database release as string ▼

Description: Technically used: Database release as string
Field Name: DBREL
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 DBREL

ORA_AWR_ASH_REPORT-INST_ID table field - Oracle monitor: Instance ID ▼

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

See all SAP tables containing field INST_ID

ORA_AWR_ASH_REPORT-SNAPID_FROM table field - ID of 'begin snapshot' (dba_hist_snapshot) ▼

Description: ID of 'begin snapshot' (dba_hist_snapshot)
Field Name: SNAPID_FROM
Data Element: ORA_HIST_SNAPID_FROM
Data Type: NUMC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_HIST_SNAPID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SNAPID_FROM

ORA_AWR_ASH_REPORT-SNAPID_TO table field - ID of 'end snapshot' (dba_hist_snapshot) ▼

Description: ID of 'end snapshot' (dba_hist_snapshot)
Field Name: SNAPID_TO
Data Element: ORA_HIST_SNAPID_TO
Data Type: NUMC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_HIST_SNAPID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SNAPID_TO

ORA_AWR_ASH_REPORT-DATE_FROM table field - Oracle mon: Time at the beginning of the snapshot interval ▼

Description: Oracle mon: Time at the beginning of the snapshot interval
Field Name: DATE_FROM
Data Element: ORA_HIST_BEG_INT_T
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 DATE_FROM

ORA_AWR_ASH_REPORT-DATE_TO table field - Oracle mon.: Time at the end of the snapshot interval ▼

Description: Oracle mon.: Time at the end of the snapshot interval
Field Name: DATE_TO
Data Element: ORA_HIST_END_INT_T
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 DATE_TO

ORA_AWR_ASH_REPORT-SNAPID_FROM2 table field - ID of 2n 'begin snapshot' (dba_hist_snapshot) ▼

Description: ID of 2n 'begin snapshot' (dba_hist_snapshot)
Field Name: SNAPID_FROM2
Data Element: ORA_HIST_SNAPID_FROM2
Data Type: NUMC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_HIST_SNAPID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SNAPID_FROM2

ORA_AWR_ASH_REPORT-SNAPID_TO2 table field - ID of 2nd 'end snapshot' (dba_hist_snapshot) ▼

Description: ID of 2nd 'end snapshot' (dba_hist_snapshot)
Field Name: SNAPID_TO2
Data Element: ORA_HIST_SNAPID_TO2
Data Type: NUMC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_HIST_SNAPID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SNAPID_TO2

ORA_AWR_ASH_REPORT-DATE_FROM2 table field - Oracle mon: Time at the beginning of the snapshot interval ▼

Description: Oracle mon: Time at the beginning of the snapshot interval
Field Name: DATE_FROM2
Data Element: ORA_HIST_BEG_INT_T
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 DATE_FROM2

ORA_AWR_ASH_REPORT-DATE_TO2 table field - Oracle mon.: Time at the end of the snapshot interval ▼

Description: Oracle mon.: Time at the end of the snapshot interval
Field Name: DATE_TO2
Data Element: ORA_HIST_END_INT_T
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 DATE_TO2

ORA_AWR_ASH_REPORT-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_AWR_ASH_REPORT-DBIO_EXPECTED table field - Oracle mon.: Average Block Read time (ms) ▼

Description: Oracle mon.: Average Block Read time (ms)
Field Name: DBIO_EXPECTED
Data Element: ORA_DBIO_EXPECTED
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBIO_EXPECTED

ORA_AWR_ASH_REPORT-REPORT table field - ▼

Description:
Field Name: REPORT
Data Element: ORA_T_STRING
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REPORT

View list of all SAP tables(S4H/ECC)

Select data from SAP table