SAP ABAP Table GVD_SQL_WA_HISTO (Oracle Monitoring: Copy of GV$SQL_WORKAREA_HISTOGRAM)

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_WA_HISTO	Table Relationship Diagram
Short Description	Oracle Monitoring: Copy of GV$SQL_WORKAREA_HISTOGRAM

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	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	SNAPSHOT_ID	☑	ORA_SNAPSHOT_ID	ORA_SNAPSHOT_ID	NUMC	10	0	Oracle monitor: snapshot ID	*
2	INST_ID	☑	ORA_INST_ID	ORA_INST_ID	DEC	22	0	Oracle monitor: Instance ID
3	LOW_OPTIMAL_SIZE	☑	ORA_WAH_LOW_OPTIMAL_SIZE	ORA_NUM_22	DEC	22	0	Oracle monitoring: Lower bound for the memory requirement
4	HIGH_OPTIMAL_SIZ	☑	ORA_WAH_HIGH_OPTIMAL_SIZE	ORA_NUM_22	DEC	22	0	Oracle monitoring: Higher bound for the memory requirement
5	OPTIMAL_EXECUTIO	☐	ORA_OPTIMAL_EXECUTIONS	ORA_NUMBER	DEC	22	0	Oracle Monitoring: OPTIMAL_EXECUTIONS
6	ONEPASS_EXECUTIO	☐	ORA_ONEPASS_EXECUTIONS	ORA_NUMBER	DEC	22	0	Oracle Monitoring: ONEPASS_EXECUTIONS
7	MULTIPASSES_EXEC	☐	ORA_MULTIPASSES_EXECUTIONS	ORA_NUMBER	DEC	22	0	Oracle Monitoring: MULTIPASSES_EXECUTIONS
8	TOTAL_EXECUTIONS	☐	ORA_TOTAL_EXECUTIONS	ORA_NUMBER	DEC	22	0	Oracle Monitoring: TOTAL_EXECUTIONS: Optimal+1pass+xpass

History

Last changed by/on	SAP	20130604
SAP Release Created in	700