SAP GVD_DB_CACHE_ADV table - Copy of GV$DB_CACHE_ADVICE (currently not provided w. snaps) details in SAP

SAP GVD_DB_CACHE_ADV table summary

Object Name: GVD_DB_CACHE_ADV
Dictionary Type: Transparent table
Description: Copy of GV$DB_CACHE_ADVICE (currently not provided w. snaps)

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

Details

GVD_DB_CACHE_ADV-SNAPSHOT_ID table field - Oracle monitor: snapshot ID ▼

Description: Oracle monitor: snapshot ID
Field Name: SNAPSHOT_ID
Data Element: ORA_SNAPSHOT_ID
Data Type: NUMC
length (Dec): 10(0)
Check table: *
Conversion Routine:
Domain Name: ORA_SNAPSHOT_ID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SNAPSHOT_ID

GVD_DB_CACHE_ADV-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

GVD_DB_CACHE_ADV-ID table field - Oracle monitoring: db cache advice id ▼

Description: Oracle monitoring: db cache advice id
Field Name: ID
Data Element: ORA_ID
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_DEC_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ID

GVD_DB_CACHE_ADV-NAME table field - Oracle monitoring: db cache advice name ▼

Description: Oracle monitoring: db cache advice name
Field Name: NAME
Data Element: ORA_NAME_DB_CACHE_ADV
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_20
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME

GVD_DB_CACHE_ADV-BLOCK_SIZE table field - Oracle monitoring: db cache advice block size ▼

Description: Oracle monitoring: db cache advice block size
Field Name: BLOCK_SIZE
Data Element: ORA_BLOCK_SIZE_DB_CACHE_ADV
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BLOCK_SIZE

GVD_DB_CACHE_ADV-ADVICE_STATUS table field - Oracle monitoring: db cache advice status ▼

Description: Oracle monitoring: db cache advice status
Field Name: ADVICE_STATUS
Data Element: ORA_ADVICE_STATUS_DB_CACHE_ADV
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_3
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ADVICE_STATUS

GVD_DB_CACHE_ADV-SIZE_FOR_ESTIMAT table field - Oracle monitoring: db cache advice size for estimate ▼

Description: Oracle monitoring: db cache advice size for estimate
Field Name: SIZE_FOR_ESTIMAT
Data Element: ORA_SIZE_FOR_ESTIMATE
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SIZE_FOR_ESTIMAT

GVD_DB_CACHE_ADV-SIZE_FACTOR table field - Oracle monitoring: db cache advice size factor ▼

Description: Oracle monitoring: db cache advice size factor
Field Name: SIZE_FACTOR
Data Element: ORA_SIZE_FACTOR
Data Type: DEC
length (Dec): 22(4)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22_4
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SIZE_FACTOR

GVD_DB_CACHE_ADV-BUFFERS_FOR_ESTI table field - Oracle monitoring: db cache advice buffers for estimate ▼

Description: Oracle monitoring: db cache advice buffers for estimate
Field Name: BUFFERS_FOR_ESTI
Data Element: ORA_BUFFERS_FOR_ESTIMATE
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BUFFERS_FOR_ESTI

GVD_DB_CACHE_ADV-ESTD_PHYS_READ_F table field - Oracle monitoring: db cache advice physical read factor ▼

Description: Oracle monitoring: db cache advice physical read factor
Field Name: ESTD_PHYS_READ_F
Data Element: ORA_ESTD_PHYSICAL_READ_FACTOR
Data Type: DEC
length (Dec): 22(4)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22_4
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ESTD_PHYS_READ_F

GVD_DB_CACHE_ADV-ESTD_PHYS_READS table field - Oracle monitoring: db cache advice estd physical reads ▼

Description: Oracle monitoring: db cache advice estd physical reads
Field Name: ESTD_PHYS_READS
Data Element: ORA_ESTD_PHYSICAL_READS
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ESTD_PHYS_READS

View list of all SAP tables(S4H/ECC)

Select data from SAP table