SAP ABAP Table ORA_SG_DCA (SDD - Oracle SGA monitor: DCA)
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
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_SG_DCA |
Table Relationship Diagram 
|
| Short Description | SDD - Oracle SGA monitor: DCA |
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 |  INST_ID |
ORA_INST_ID | ORA_INST_ID | DEC | 22 | 0 | Oracle monitor: Instance ID | ||
| 2 | INSTANCE_NAME |
ORA_INSTANCE_NAME | ORA_LK_INSTNAME | CHAR | 48 | 0 | Oracle monitoring: instance_name | ||
| 3 | ID |
ORA_SG_DCA_ID | ORA_SG_DEC_22_0 | DEC | 22 | 0 | SDD - Oracle SGA monitor: ID | ||
| 4 | NAME |
ORA_SG_DCA_NAME | ORA_SG_DCA_NAME | CHAR | 20 | 0 | SDD - Oracle SGA monitor: Name | ||
| 5 | BLOCK_SIZE |
ORA_SG_BLKSIZE | ORA_SG_NUM22 | DEC | 22 | 0 | SDD - Oracle lock monitor: BLKSIZE | ||
| 6 | ADVICE_STATUS |
ORA_SG_DCA_ADVS | ORA_SG_DCA_ADVS | CHAR | 3 | 0 | SDD - Oracle SGA monitor: Advice Status | ||
| 7 | SIZE_FOR_ESTIMAT |
ORA_SG_DCA_SFE | ORA_SG_DEC_22_0 | DEC | 22 | 0 | SDD - Oracle SGA monitor: Size for Estimate | ||
| 8 | SIZE_FACTOR |
ORA_SG_DCA_SF | ORA_SG_DEC_22_4 | DEC | 22 | 4 | SDD - Oracle SGA monitor: Size Factor | ||
| 9 | BUFFERS_FOR_ESTI |
ORA_SG_DCA_BFE | ORA_SG_DEC_22_0 | DEC | 22 | 0 | SDD - Oracle SGA monitor: BPE | ||
| 10 | ESTD_PHYS_READ_F |
ORA_SG_DCA_EPRF | ORA_SG_DEC_22_4 | DEC | 22 | 4 | SDD - Oracle SGA monitor: Est. Phys REad Factor | ||
| 11 | ESTD_PHYS_READS |
ORA_SG_DCA_EPR | ORA_SG_DEC_22_0 | DEC | 22 | 0 | SDD - Oracle SGA monitor: Estd. Phys REads | ||
| 12 | ESTD_PHYSICAL_READ_TIME |
ORA_SG_DCA_EPRT | ORA_SG_DEC_22_4 | DEC | 22 | 4 | SDD - Oracle SGA monitor: Est. Phys Read time | ||
| 13 | ESTD_PCT_OF_DB_TIME_FOR_READS |
ORA_SG_DCA_EPDTFR | ORA_SG_DEC_22_4 | DEC | 22 | 4 | SDD - Oracle SGA monitor: Est. PCT of DB time for reads |
History
| Last changed by/on | SAP | 20140117 |
| SAP Release Created in | 700 |
