SAP ABAP Table GPG_TR_SQLHIS (PGA Monitoring: (g)v$SQL (g)v$SQL_WORKAREA_HISTOGRAM 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_SQLHIS	Table Relationship Diagram
Short Description	PGA Monitoring: (g)v$SQL (g)v$SQL_WORKAREA_HISTOGRAM 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	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	20140117
SAP Release Created in	710