SAP Table ORA_SG_DCA
SDD - Oracle SGA monitor: DCA
ORA_SG_DCA (SDD - Oracle SGA monitor: DCA) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link ORA_SG_DCA to other SAP tables.
ORA_SG_DCA table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| INST_ID | Oracle monitor: Instance ID | ORA_INST_ID | DEC | 22 | 0 | |||
| INSTANCE_NAME | Oracle monitoring: instance_name | ORA_INSTANCE_NAME | CHAR | 48 | 0 | |||
| ID | SDD - Oracle SGA monitor: ID | ORA_SG_DCA_ID | DEC | 22 | 0 | |||
| NAME | SDD - Oracle SGA monitor: Name | ORA_SG_DCA_NAME | CHAR | 20 | 0 | |||
| BLOCK_SIZE | SDD - Oracle lock monitor: BLKSIZE | ORA_SG_BLKSIZE | DEC | 22 | 0 | |||
| ADVICE_STATUS | SDD - Oracle SGA monitor: Advice Status | ORA_SG_DCA_ADVS | CHAR | 3 | 0 | |||
| SIZE_FOR_ESTIMAT | SDD - Oracle SGA monitor: Size for Estimate | ORA_SG_DCA_SFE | DEC | 22 | 0 | |||
| SIZE_FACTOR | SDD - Oracle SGA monitor: Size Factor | ORA_SG_DCA_SF | DEC | 22 | 4 | |||
| BUFFERS_FOR_ESTI | SDD - Oracle SGA monitor: BPE | ORA_SG_DCA_BFE | DEC | 22 | 0 | |||
| ESTD_PHYS_READ_F | SDD - Oracle SGA monitor: Est. Phys REad Factor | ORA_SG_DCA_EPRF | DEC | 22 | 4 | |||
| ESTD_PHYS_READS | SDD - Oracle SGA monitor: Estd. Phys REads | ORA_SG_DCA_EPR | DEC | 22 | 0 | |||
| ESTD_PHYSICAL_READ_TIME | SDD - Oracle SGA monitor: Est. Phys Read time | ORA_SG_DCA_EPRT | DEC | 22 | 4 | |||
| ESTD_PCT_OF_DB_TIME_FOR_READS | SDD - Oracle SGA monitor: Est. PCT of DB time for reads | ORA_SG_DCA_EPDTFR | DEC | 22 | 4 | |||
