SAP GPG_TR_SQLWOA table - PGA Monitoring: (g)v$SQL_WORKAREA table details in SAP

SAP GPG_TR_SQLWOA table summary

Object Name: GPG_TR_SQLWOA
Dictionary Type: Structure
Description: PGA Monitoring: (g)v$SQL_WORKAREA table

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

Details

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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