SAP ABAP Table ORA_AWR_ASH_REPORT (Oracle monitoring: data for AWR and ASH reports)
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
⤷ 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_ASH_REPORT | Table Relationship Diagram |
Short Description | Oracle monitoring: data for AWR and ASH reports |
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 | DATE_FROM | ORA_HIST_BEG_INT_T | ORA_CHAR_22 | CHAR | 22 | 0 | Oracle mon: Time at the beginning of the snapshot interval | ||
9 | DATE_TO | ORA_HIST_END_INT_T | ORA_CHAR_22 | CHAR | 22 | 0 | Oracle mon.: Time at the end of the snapshot interval | ||
10 | SNAPID_FROM2 | ORA_HIST_SNAPID_FROM2 | ORA_HIST_SNAPID | NUMC | 22 | 0 | ID of 2n "begin snapshot" (dba_hist_snapshot) | ||
11 | SNAPID_TO2 | ORA_HIST_SNAPID_TO2 | ORA_HIST_SNAPID | NUMC | 22 | 0 | ID of 2nd "end snapshot" (dba_hist_snapshot) | ||
12 | DATE_FROM2 | ORA_HIST_BEG_INT_T | ORA_CHAR_22 | CHAR | 22 | 0 | Oracle mon: Time at the beginning of the snapshot interval | ||
13 | DATE_TO2 | ORA_HIST_END_INT_T | ORA_CHAR_22 | CHAR | 22 | 0 | Oracle mon.: Time at the end of the snapshot interval | ||
14 | SQLID | ORA_SQL_ID | ORA_SQLID | CHAR | 13 | 0 | Oracle monitoring: SQL_ID | ||
15 | DBIO_EXPECTED | ORA_DBIO_EXPECTED | INT4 | 10 | 0 | Oracle mon.: Average Block Read time (ms) | |||
16 | REPORT | ORA_T_STRING | TTYP | 0 | 0 |
History
Last changed by/on | SAP | 20110908 |
SAP Release Created in | 710 |