Menu

SAP Table GVD_SQL_WA_HISTO

Oracle Monitoring: Copy of GV$SQL_WORKAREA_HISTOGRAM

The table GVD_SQL_WA_HISTO (Oracle Monitoring: Copy of GV$SQL_WORKAREA_HISTOGRAM) is a standard table in SAP ERP. It belongs to the package STUN.

Technical Information

Table GVD_SQL_WA_HISTO
Short Text Oracle Monitoring: Copy of GV$SQL_WORKAREA_HISTOGRAM
Package STUN
Table Type Transparent Table

Fields for Table GVD_SQL_WA_HISTO

Field Name Key Description Data Element Type Length Check Table
SNAPSHOT_ID Oracle monitor: snapshot ID ORA_SNAPSHOT_ID NUMC 10 *
INST_ID Oracle monitor: Instance ID ORA_INST_ID DEC 22
LOW_OPTIMAL_SIZE Oracle monitoring: Lower bound for the memory requirement ORA_WAH_LOW_OPTIMAL_SIZE DEC 22
HIGH_OPTIMAL_SIZ Oracle monitoring: Higher bound for the memory requirement ORA_WAH_HIGH_OPTIMAL_SIZE DEC 22
OPTIMAL_EXECUTIO Oracle Monitoring: OPTIMAL_EXECUTIONS ORA_OPTIMAL_EXECUTIONS DEC 22
ONEPASS_EXECUTIO Oracle Monitoring: ONEPASS_EXECUTIONS ORA_ONEPASS_EXECUTIONS DEC 22
MULTIPASSES_EXEC Oracle Monitoring: MULTIPASSES_EXECUTIONS ORA_MULTIPASSES_EXECUTIONS DEC 22
TOTAL_EXECUTIONS Oracle Monitoring: TOTAL_EXECUTIONS: Optimal+1pass+xpass ORA_TOTAL_EXECUTIONS DEC 22