SAP ORA_SG_DCA table - SDD - Oracle SGA monitor: DCA details in SAP

SAP ORA_SG_DCA table summary

Object Name: ORA_SG_DCA
Dictionary Type: Structure
Description: SDD - Oracle SGA monitor: DCA

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

Details

ORA_SG_DCA-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_SG_DCA-INSTANCE_NAME table field - Oracle monitoring: instance_name ▼

Description: Oracle monitoring: instance_name
Field Name: INSTANCE_NAME
Data Element: ORA_INSTANCE_NAME
Data Type: CHAR
length (Dec): 48(0)
Check table:
Conversion Routine:
Domain Name: ORA_LK_INSTNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INSTANCE_NAME

ORA_SG_DCA-ID table field - SDD - Oracle SGA monitor: ID ▼

Description: SDD - Oracle SGA monitor: ID
Field Name: ID
Data Element: ORA_SG_DCA_ID
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_SG_DEC_22_0
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ID

ORA_SG_DCA-NAME table field - SDD - Oracle SGA monitor: Name ▼

Description: SDD - Oracle SGA monitor: Name
Field Name: NAME
Data Element: ORA_SG_DCA_NAME
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: ORA_SG_DCA_NAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME

ORA_SG_DCA-BLOCK_SIZE table field - SDD - Oracle lock monitor: BLKSIZE ▼

Description: SDD - Oracle lock monitor: BLKSIZE
Field Name: BLOCK_SIZE
Data Element: ORA_SG_BLKSIZE
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_SG_NUM22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BLOCK_SIZE

ORA_SG_DCA-ADVICE_STATUS table field - SDD - Oracle SGA monitor: Advice Status ▼

Description: SDD - Oracle SGA monitor: Advice Status
Field Name: ADVICE_STATUS
Data Element: ORA_SG_DCA_ADVS
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: ORA_SG_DCA_ADVS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ADVICE_STATUS

ORA_SG_DCA-SIZE_FOR_ESTIMAT table field - SDD - Oracle SGA monitor: Size for Estimate ▼

Description: SDD - Oracle SGA monitor: Size for Estimate
Field Name: SIZE_FOR_ESTIMAT
Data Element: ORA_SG_DCA_SFE
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_SG_DEC_22_0
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SIZE_FOR_ESTIMAT

ORA_SG_DCA-SIZE_FACTOR table field - SDD - Oracle SGA monitor: Size Factor ▼

Description: SDD - Oracle SGA monitor: Size Factor
Field Name: SIZE_FACTOR
Data Element: ORA_SG_DCA_SF
Data Type: DEC
length (Dec): 22(4)
Check table:
Conversion Routine:
Domain Name: ORA_SG_DEC_22_4
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SIZE_FACTOR

ORA_SG_DCA-BUFFERS_FOR_ESTI table field - SDD - Oracle SGA monitor: BPE ▼

Description: SDD - Oracle SGA monitor: BPE
Field Name: BUFFERS_FOR_ESTI
Data Element: ORA_SG_DCA_BFE
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_SG_DEC_22_0
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BUFFERS_FOR_ESTI

ORA_SG_DCA-ESTD_PHYS_READ_F table field - SDD - Oracle SGA monitor: Est. Phys REad Factor ▼

Description: SDD - Oracle SGA monitor: Est. Phys REad Factor
Field Name: ESTD_PHYS_READ_F
Data Element: ORA_SG_DCA_EPRF
Data Type: DEC
length (Dec): 22(4)
Check table:
Conversion Routine:
Domain Name: ORA_SG_DEC_22_4
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ESTD_PHYS_READ_F

ORA_SG_DCA-ESTD_PHYS_READS table field - SDD - Oracle SGA monitor: Estd. Phys REads ▼

Description: SDD - Oracle SGA monitor: Estd. Phys REads
Field Name: ESTD_PHYS_READS
Data Element: ORA_SG_DCA_EPR
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_SG_DEC_22_0
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ESTD_PHYS_READS

ORA_SG_DCA-ESTD_PHYSICAL_READ_TIME table field - SDD - Oracle SGA monitor: Est. Phys Read time ▼

Description: SDD - Oracle SGA monitor: Est. Phys Read time
Field Name: ESTD_PHYSICAL_READ_TIME
Data Element: ORA_SG_DCA_EPRT
Data Type: DEC
length (Dec): 22(4)
Check table:
Conversion Routine:
Domain Name: ORA_SG_DEC_22_4
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ESTD_PHYSICAL_READ_TIME

ORA_SG_DCA-ESTD_PCT_OF_DB_TIME_FOR_READS table field - SDD - Oracle SGA monitor: Est. PCT of DB time for reads ▼

Description: SDD - Oracle SGA monitor: Est. PCT of DB time for reads
Field Name: ESTD_PCT_OF_DB_TIME_FOR_READS
Data Element: ORA_SG_DCA_EPDTFR
Data Type: DEC
length (Dec): 22(4)
Check table:
Conversion Routine:
Domain Name: ORA_SG_DEC_22_4
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ESTD_PCT_OF_DB_TIME_FOR_READS

View list of all SAP tables(S4H/ECC)

Select data from SAP table