SAP GVD_PGA_TARGET_H table - Copy of GV$PGA_TARGET_ADVICE_HISTOGRAM details in SAP

SAP GVD_PGA_TARGET_H table summary

Object Name: GVD_PGA_TARGET_H
Dictionary Type: Transparent table
Description: Copy of GV$PGA_TARGET_ADVICE_HISTOGRAM

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

Details

GVD_PGA_TARGET_H-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_PGA_TARGET_H-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_PGA_TARGET_H-SAP_LINE_NR table field - Help field: Line Nr. (to avoid duplicate entries) ▼

Description: Help field: Line Nr. (to avoid duplicate entries)
Field Name: SAP_LINE_NR
Data Element: ORA_SAPLINENR
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SAP_LINE_NR

GVD_PGA_TARGET_H-PGA_TARGET_FOR_E table field - Oracle monitoring: Value of PGA_AGGREGATE_TARGET (in bytes) ▼

Description: Oracle monitoring: Value of PGA_AGGREGATE_TARGET (in bytes)
Field Name: PGA_TARGET_FOR_E
Data Element: ORA_PGA_TARGET_FOR_ESTIMATE
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 PGA_TARGET_FOR_E

GVD_PGA_TARGET_H-PGA_TARGET_FACTO table field - Oracle monitoring:PGA_TARGET_FOR_ESTIMATE/PGA_AGGREGATE_TAR% ▼

Description: Oracle monitoring:PGA_TARGET_FOR_ESTIMATE/PGA_AGGREGATE_TAR%
Field Name: PGA_TARGET_FACTO
Data Element: ORA_PGA_TARGET_FACTOR
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 PGA_TARGET_FACTO

GVD_PGA_TARGET_H-ADVICE_STATUS table field - Oracle monitoring: Advice is enabled (ON) or disabled (OFF) ▼

Description: Oracle monitoring: Advice is enabled (ON) or disabled (OFF)
Field Name: ADVICE_STATUS
Data Element: ORA_ADVICE_STATUS
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: ORA_ADVICE_STATUS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ADVICE_STATUS

GVD_PGA_TARGET_H-LOW_OPTIMAL_SIZE table field - Oracle monitoring: Lower bound for the memory requirement ▼

Description: Oracle monitoring: Lower bound for the memory requirement
Field Name: LOW_OPTIMAL_SIZE
Data Element: ORA_LOW_OPTIMAL_SIZE
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOW_OPTIMAL_SIZE

GVD_PGA_TARGET_H-HIGH_OPTIMAL_SIZ table field - Oracle monitoring: Higher bound for the memory requirement ▼

Description: Oracle monitoring: Higher bound for the memory requirement
Field Name: HIGH_OPTIMAL_SIZ
Data Element: ORA_HIGH_OPTIMAL_SIZE
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HIGH_OPTIMAL_SIZ

GVD_PGA_TARGET_H-ESTD_OPTIMAL_EXE table field - Oracle monitoring: Number of work areas - Optimal ▼

Description: Oracle monitoring: Number of work areas - Optimal
Field Name: ESTD_OPTIMAL_EXE
Data Element: ORA_ESTD_OPTIMAL_EXECUTIONS
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ESTD_OPTIMAL_EXE

GVD_PGA_TARGET_H-ESTD_ONEPASS_EXE table field - Oracle monitoring: Number of work areas - One Pass ▼

Description: Oracle monitoring: Number of work areas - One Pass
Field Name: ESTD_ONEPASS_EXE
Data Element: ORA_ESTD_ONEPASS_EXECUTIONS
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ESTD_ONEPASS_EXE

GVD_PGA_TARGET_H-ESTD_MULTIPASS_E table field - Oracle monitoring: Number of work areas - Multi Pass ▼

Description: Oracle monitoring: Number of work areas - Multi Pass
Field Name: ESTD_MULTIPASS_E
Data Element: ORA_ESTD_MULTIPASS_EXECUTIONS
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ESTD_MULTIPASS_E

GVD_PGA_TARGET_H-ESTD_TOTAL_EXECU table field - Oracle monitoring: Sum of work areas(Optim+OnePas+MultiPas) ▼

Description: Oracle monitoring: Sum of work areas(Optim+OnePas+MultiPas)
Field Name: ESTD_TOTAL_EXECU
Data Element: ORA_ESTD_TOTAL_EXECUTIONS
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ESTD_TOTAL_EXECU

GVD_PGA_TARGET_H-IGNORED_WORKAREA table field - Oracle monitoring: Number of work areas - Ignored ▼

Description: Oracle monitoring: Number of work areas - Ignored
Field Name: IGNORED_WORKAREA
Data Element: ORA_IGNORED_WORKAREAS_COUNT
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field IGNORED_WORKAREA

View list of all SAP tables(S4H/ECC)

Select data from SAP table