SAP ABAP Table ORA_AWR_REPORT (Oracle monitoring: data for AWR report)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON-ORA (Application Component) Oracle Database Monitors
     ⤷ S_DBMON_ORA_COCKPIT (Package) Database Monitor for Oracle in Cockpit Framework

Basic Data

Table Category	INTTAB	Structure
Structure	ORA_AWR_REPORT	Table Relationship Diagram
Short Description	Oracle monitoring: data for AWR report

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	REMOTE_SYSTEM	☐	DBCON_NAME	DBCON_NAME	CHAR	30	0	Logical name for a database connection	*
2	DBID	☐	ORA_DBID	ORA_DEC_22	DEC	22	0	Oracle monitoring: database id
3	DBNAME	☐	ORA_NAME_DB	ORA_CHAR_9	CHAR	9	0	Oracle monitoring: database name
4	DBREL	☐			STRG	0	0
5	INST_ID	☐	ORA_INST_ID	ORA_INST_ID	DEC	22	0	Oracle monitor: Instance ID
6	SNAPID_FROM	☐	ORA_HIST_SNAPID_FROM	ORA_HIST_SNAPID	NUMC	22	0	ID of "begin snapshot" (dba_hist_snapshot)
7	SNAPID_TO	☐	ORA_HIST_SNAPID_TO	ORA_HIST_SNAPID	NUMC	22	0	ID of "end snapshot" (dba_hist_snapshot)
8	SNAPID_FROM2	☐	ORA_HIST_SNAPID_FROM2	ORA_HIST_SNAPID	NUMC	22	0	ID of 2n "begin snapshot" (dba_hist_snapshot)
9	SNAPID_TO2	☐	ORA_HIST_SNAPID_TO2	ORA_HIST_SNAPID	NUMC	22	0	ID of 2nd "end snapshot" (dba_hist_snapshot)
10	SQLID	☐	ORA_SQL_ID	ORA_SQLID	CHAR	13	0	Oracle monitoring: SQL_ID
11	DBIO_EXPECTED	☐	ORA_DBIO_EXPECTED		INT4	10	0	Oracle mon.: Average Block Read time (ms)
12	REPORT	☐	ORA_T_STRING		TTYP	0	0

History

Last changed by/on	SAP	20110908
SAP Release Created in	710