DBA Data[Home] [Help]

VIEW: SYS.V_$SQL_WORKAREA_HISTOGRAM

Source

View Text - Preformatted

select "LOW_OPTIMAL_SIZE","HIGH_OPTIMAL_SIZE","OPTIMAL_EXECUTIONS","ONEPASS_EXECUTIONS","MULTIPASSES_EXECUTIONS","TOTAL_EXECUTIONS","CON_ID" from v$sql_workarea_histogram
View Text - HTML Formatted

SELECT "LOW_OPTIMAL_SIZE"
, "HIGH_OPTIMAL_SIZE"
, "OPTIMAL_EXECUTIONS"
, "ONEPASS_EXECUTIONS"
, "MULTIPASSES_EXECUTIONS"
, "TOTAL_EXECUTIONS"
, "CON_ID"
FROM V$SQL_WORKAREA_HISTOGRAM