SAP ABAP Table GVD_SQL_WORKAREA (Oracle Monitoring: Copy of GV$SQL_WORKAREA) - SAP Datasheet

The Best Online SAP Object Repository

Object Hierarchy

Software Component

SAP_BASIS

Application Component ID

BC-CCM-MON-TUN

Package

STUN

Object type

Transparent table

Object name

GVD_SQL_WORKAREA

Using

Data Element (21)

Used by

Not Used by Anyone

Advertise Links

SAP ABAP Table GVD_SQL_WORKAREA (Oracle Monitoring: Copy of GV$SQL_WORKAREA)

Hierarchy

☛

SAP_BASIS (Software Component) SAP Basis Component
⤷

BC-CCM-MON-TUN (Application Component) Performance Monitors (TCC)
⤷

STUN (Package) DBA: All the rest in English

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	GVD_SQL_WORKAREA	Table Relationship Diagram
Short Description	Oracle Monitoring: Copy of GV$SQL_WORKAREA

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


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