SAP GVD_SQL_WORKAREA table - Oracle Monitoring: Copy of GV$SQL_WORKAREA details in SAP

SAP GVD_SQL_WORKAREA table summary

Object Name: GVD_SQL_WORKAREA
Dictionary Type: Transparent table
Description: Oracle Monitoring: Copy of GV$SQL_WORKAREA

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

Details

GVD_SQL_WORKAREA-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_SQL_WORKAREA-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_SQL_WORKAREA-WORKAREA_ADDRESS table field - Oracle Monitoring: WORKAREA_ADDRESS: @ of w.a. handle ▼

Description: Oracle Monitoring: WORKAREA_ADDRESS: @ of w.a. handle
Field Name: WORKAREA_ADDRESS
Data Element: ORA_WORKAREA_ADDRESS
Data Type: RAW
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: ORA_RAW_8
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WORKAREA_ADDRESS

GVD_SQL_WORKAREA-ADDRESS table field - Oracle Monitoring: ADDRESS: @ of Handle to Parent Cursor ▼

Description: Oracle Monitoring: ADDRESS: @ of Handle to Parent Cursor
Field Name: ADDRESS
Data Element: ORA_ADDRESS
Data Type: RAW
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: ORA_RAW_8
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ADDRESS

GVD_SQL_WORKAREA-HASH_VALUE table field - Oracle Monitoring: HASH_VALUE: Hash Value of Parent Statment ▼

Description: Oracle Monitoring: HASH_VALUE: Hash Value of Parent Statment
Field Name: HASH_VALUE
Data Element: ORA_HASH_VALUE
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 HASH_VALUE

GVD_SQL_WORKAREA-CHILD_NUMBER table field - Oracle Monitoring: CHILD_NUMBER ▼

Description: Oracle Monitoring: CHILD_NUMBER
Field Name: CHILD_NUMBER
Data Element: ORA_CHILD_NUMBER
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 CHILD_NUMBER

GVD_SQL_WORKAREA-OPERATION_TYPE table field - Oracle Monitoring: OPERATION_TYPE ▼

Description: Oracle Monitoring: OPERATION_TYPE
Field Name: OPERATION_TYPE
Data Element: ORA_OPERATION_TYPE
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 OPERATION_TYPE

GVD_SQL_WORKAREA-OPERATION_ID table field - Oracle Monitoring: OPERATION_ID ▼

Description: Oracle Monitoring: OPERATION_ID
Field Name: OPERATION_ID
Data Element: ORA_OPERATION_ID
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 OPERATION_ID

GVD_SQL_WORKAREA-POLICY table field - Oracle Monitoring: POLICY: Sizing Policy (Manual or Auto) ▼

Description: Oracle Monitoring: POLICY: Sizing Policy (Manual or Auto)
Field Name: POLICY
Data Element: ORA_POLICY
Data Type: CHAR
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_6
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POLICY

GVD_SQL_WORKAREA-ESTIMATED_OPTIMA table field - Oracle Monitoring: ESTIMATED_OPTIMAL_SIZE ▼

Description: Oracle Monitoring: ESTIMATED_OPTIMAL_SIZE
Field Name: ESTIMATED_OPTIMA
Data Element: ORA_ESTIMATED_OPTIMAL_SIZE
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 ESTIMATED_OPTIMA

GVD_SQL_WORKAREA-ESTIMATED_ONEPAS table field - Oracle Monitoring: ESTIMATED_ONEPASS_SIZE ▼

Description: Oracle Monitoring: ESTIMATED_ONEPASS_SIZE
Field Name: ESTIMATED_ONEPAS
Data Element: ORA_ESTIMATED_ONEPASS_SIZE
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 ESTIMATED_ONEPAS

GVD_SQL_WORKAREA-LAST_MEMORY_USED table field - Oracle Monitoring: LAST_MEMORY_USED: Mem used for last exec ▼

Description: Oracle Monitoring: LAST_MEMORY_USED: Mem used for last exec
Field Name: LAST_MEMORY_USED
Data Element: ORA_LAST_MEMORY_USED
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 LAST_MEMORY_USED

GVD_SQL_WORKAREA-LAST_EXECUTION table field - Oracle Monitoring: LAST_EXECUTION ▼

Description: Oracle Monitoring: LAST_EXECUTION
Field Name: LAST_EXECUTION
Data Element: ORA_LAST_EXECUTION
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_10
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LAST_EXECUTION

GVD_SQL_WORKAREA-LAST_DEGREE table field - Oracle Monitoring: LAST_DEGREE: Deg of Parallelism of last ▼

Description: Oracle Monitoring: LAST_DEGREE: Deg of Parallelism of last
Field Name: LAST_DEGREE
Data Element: ORA_LAST_DEGREE
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 LAST_DEGREE

GVD_SQL_WORKAREA-TOTAL_EXECUTIONS table field - Oracle Monitoring: TOTAL_EXECUTIONS: Optimal+1pass+xpass ▼

Description: Oracle Monitoring: TOTAL_EXECUTIONS: Optimal+1pass+xpass
Field Name: TOTAL_EXECUTIONS
Data Element: ORA_TOTAL_EXECUTIONS
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 TOTAL_EXECUTIONS

GVD_SQL_WORKAREA-OPTIMAL_EXECUTIO table field - Oracle Monitoring: OPTIMAL_EXECUTIONS ▼

Description: Oracle Monitoring: OPTIMAL_EXECUTIONS
Field Name: OPTIMAL_EXECUTIO
Data Element: ORA_OPTIMAL_EXECUTIONS
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 OPTIMAL_EXECUTIO

GVD_SQL_WORKAREA-ONEPASS_EXECUTIO table field - Oracle Monitoring: ONEPASS_EXECUTIONS ▼

Description: Oracle Monitoring: ONEPASS_EXECUTIONS
Field Name: ONEPASS_EXECUTIO
Data Element: ORA_ONEPASS_EXECUTIONS
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 ONEPASS_EXECUTIO

GVD_SQL_WORKAREA-MULTIPASSES_EXEC table field - Oracle Monitoring: MULTIPASSES_EXECUTIONS ▼

Description: Oracle Monitoring: MULTIPASSES_EXECUTIONS
Field Name: MULTIPASSES_EXEC
Data Element: ORA_MULTIPASSES_EXECUTIONS
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 MULTIPASSES_EXEC

GVD_SQL_WORKAREA-ACTIVE_TIME table field - Oracle Monitoring: ACTIVE_TIME: Average Active Time ▼

Description: Oracle Monitoring: ACTIVE_TIME: Average Active Time
Field Name: ACTIVE_TIME
Data Element: ORA_ACTIVE_TIME
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 ACTIVE_TIME

GVD_SQL_WORKAREA-MAX_TEMPSEG_SIZE table field - Oracle Monitoring: MAX_TEMPSEG_SIZE ▼

Description: Oracle Monitoring: MAX_TEMPSEG_SIZE
Field Name: MAX_TEMPSEG_SIZE
Data Element: ORA_MAX_TEMPSEG_SIZE
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 MAX_TEMPSEG_SIZE

GVD_SQL_WORKAREA-LAST_TEMPSEG_SIZ table field - Oracle Monitoring: LAST_TEMPSEG_SIZE ▼

Description: Oracle Monitoring: LAST_TEMPSEG_SIZE
Field Name: LAST_TEMPSEG_SIZ
Data Element: ORA_LAST_TEMPSEG_SIZE
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 LAST_TEMPSEG_SIZ

View list of all SAP tables(S4H/ECC)

Select data from SAP table