DBA Data[Home] [Help]

VIEW: SYS.DBA_HIST_SQL_WORKAREA_HSTGRM

Source

View Text - Preformatted

select "SNAP_ID","DBID","INSTANCE_NUMBER","LOW_OPTIMAL_SIZE","HIGH_OPTIMAL_SIZE","OPTIMAL_EXECUTIONS","ONEPASS_EXECUTIONS","MULTIPASSES_EXECUTIONS","TOTAL_EXECUTIONS","CON_DBID","CON_ID" from INT$DBA_HIST_SQL_WA_HSTGRM
View Text - HTML Formatted

SELECT "SNAP_ID"
, "DBID"
, "INSTANCE_NUMBER"
, "LOW_OPTIMAL_SIZE"
, "HIGH_OPTIMAL_SIZE"
, "OPTIMAL_EXECUTIONS"
, "ONEPASS_EXECUTIONS"
, "MULTIPASSES_EXECUTIONS"
, "TOTAL_EXECUTIONS"
, "CON_DBID"
, "CON_ID"
FROM INT$DBA_HIST_SQL_WA_HSTGRM