SAP ABAP Table GPG_TR_SQLWOA (PGA Monitoring: (g)v$SQL_WORKAREA table)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON-ORA (Application Component) Oracle Database Monitors
     ⤷ S_DBMON_ORA_COCKPIT (Package) Database Monitor for Oracle in Cockpit Framework

Basic Data

Table Category	INTTAB	Structure
Structure	GPG_TR_SQLWOA	Table Relationship Diagram
Short Description	PGA Monitoring: (g)v$SQL_WORKAREA table

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	INST_ID	☐	ORA_INST_ID	ORA_INST_ID	DEC	22	0	Oracle monitor: Instance ID
2	INSTANCE_NAME	☐	ORA_INSTANCE_NAME	ORA_LK_INSTNAME	CHAR	48	0	Oracle monitoring: instance_name
3	ADDRESS	☐	ORA_ADDRESS	ORA_RAW_8	RAW	8	0	Oracle Monitoring: ADDRESS: @ of Handle to Parent Cursor
4	HASH_VALUE	☐	ORA_HASH_VALUE	ORA_NUMBER	DEC	22	0	Oracle Monitoring: HASH_VALUE: Hash Value of Parent Statment
5	CHILD_NUMBER	☐	ORA_CHILD_NUMBER	ORA_NUMBER	DEC	22	0	Oracle Monitoring: CHILD_NUMBER
6	WORKAREA_ADDRESS	☐	ORA_WORKAREA_ADDRESS	ORA_RAW_8	RAW	8	0	Oracle Monitoring: WORKAREA_ADDRESS: @ of w.a. handle
7	OPERATION_TYPE	☐	ORA_OPERATION_TYPE	ORA_CHAR_20	CHAR	20	0	Oracle Monitoring: OPERATION_TYPE
8	OPERATION_ID	☐	ORA_OPERATION_ID	ORA_NUMBER	DEC	22	0	Oracle Monitoring: OPERATION_ID
9	POLICY	☐	ORA_POLICY	ORA_CHAR_6	CHAR	6	0	Oracle Monitoring: POLICY: Sizing Policy (Manual or Auto)
10	ESTIMATED_OPTIMA	☐	ORA_ESTIMATED_OPTIMAL_SIZE	ORA_NUMBER	DEC	22	0	Oracle Monitoring: ESTIMATED_OPTIMAL_SIZE
11	ESTIMATED_ONEPAS	☐	ORA_ESTIMATED_ONEPASS_SIZE	ORA_NUMBER	DEC	22	0	Oracle Monitoring: ESTIMATED_ONEPASS_SIZE
12	LAST_MEMORY_USED	☐	ORA_LAST_MEMORY_USED	ORA_NUMBER	DEC	22	0	Oracle Monitoring: LAST_MEMORY_USED: Mem used for last exec
13	LAST_EXECUTION	☐	ORA_LAST_EXECUTION	ORA_CHAR_10	CHAR	10	0	Oracle Monitoring: LAST_EXECUTION
14	LAST_DEGREE	☐	ORA_LAST_DEGREE	ORA_NUMBER	DEC	22	0	Oracle Monitoring: LAST_DEGREE: Deg of Parallelism of last
15	TOTAL_EXECUTIONS	☐	ORA_TOTAL_EXECUTIONS	ORA_NUMBER	DEC	22	0	Oracle Monitoring: TOTAL_EXECUTIONS: Optimal+1pass+xpass
16	OPTIMAL_EXECUTIO	☐	ORA_OPTIMAL_EXECUTIONS	ORA_NUMBER	DEC	22	0	Oracle Monitoring: OPTIMAL_EXECUTIONS
17	ONEPASS_EXECUTIO	☐	ORA_ONEPASS_EXECUTIONS	ORA_NUMBER	DEC	22	0	Oracle Monitoring: ONEPASS_EXECUTIONS
18	MULTIPASSES_EXEC	☐	ORA_MULTIPASSES_EXECUTIONS	ORA_NUMBER	DEC	22	0	Oracle Monitoring: MULTIPASSES_EXECUTIONS
19	ACTIVE_TIME	☐	ORA_ACTIVE_TIME	ORA_NUMBER	DEC	22	0	Oracle Monitoring: ACTIVE_TIME: Average Active Time
20	MAX_TEMPSEG_SIZE	☐	ORA_MAX_TEMPSEG_SIZE	ORA_NUMBER	DEC	22	0	Oracle Monitoring: MAX_TEMPSEG_SIZE
21	LAST_TEMPSEG_SIZ	☐	ORA_LAST_TEMPSEG_SIZE	ORA_NUMBER	DEC	22	0	Oracle Monitoring: LAST_TEMPSEG_SIZE

History

Last changed by/on	SAP	20140117
SAP Release Created in	710