SAP ORA_AWR_REPORT table - Oracle monitoring: data for AWR report details in SAP

SAP ORA_AWR_REPORT table summary

Warning: Undefined array key "id" in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 101

Object Name: ORA_AWR_REPORT
Dictionary Type: Structure
Description: Oracle monitoring: data for AWR report

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

Details

ORA_AWR_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_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_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_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_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_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_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_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_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_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_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_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

Warning: Undefined variable $ucsaptab in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 234 Warning: Undefined variable $ucsaptab in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 278 Warning: Undefined variable $obj1 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj2 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj3 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj4 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj5 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj6 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj7 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj8 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj9 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj10 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj11 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279

View list of all SAP tables(S4H/ECC)

Select data from SAP table