V$SQL_WORKAREA_HISTOGRAM

Columns
   ___________________________
 
   LOW_OPTIMAL_SIZE
   HIGH_OPTIMAL_SIZE
   OPTIMAL_EXECUTIONS
   ONEPASS_EXECUTIONS
   MULTIPASSES_EXECUTIONS
   TOTAL_EXECUTIONS

Related:

 V$OPEN_CURSOR 
 V$SQL 
 V$SQLAREA 
 V$SQLTEXT 
 V$SQLTEXT_WITH_NEWLINES 
 V$SQLXS 
 V$SQL_BIND_DATA 
 V$SQL_BIND_METADATA 
 V$SQL_CURSOR 
 V$SQL_REDIRECTION 
 V$SQL_SHARED_CURSOR 
 V$SQL_SHARED_MEMORY 
 V$SQL_WORKAREA 
 V$SQL_WORKAREA_ACTIVE