V$SQL_WORKAREA

Data Dictionary View

Columns
   ___________________________
 
   ADDRESS
   HASH_VALUE
   CHILD_NUMBER
   WORKAREA_ADDRESS
   OPERATION_TYPE
   OPERATION_ID
   POLICY
   ESTIMATED_OPTIMAL_SIZE
   ESTIMATED_ONEPASS_SIZE
   LAST_MEMORY_USED
   LAST_EXECUTION
   LAST_DEGREE
   TOTAL_EXECUTIONS
   OPTIMAL_EXECUTIONS
   ONEPASS_EXECUTIONS
   MULTIPASSES_EXECUTIONS
   ACTIVE_TIME
   MAX_TEMPSEG_SIZE
   LAST_TEMPSEG_SIZE

Related:

 V$OPEN_CURSOR 
 V$SQL.address / .hash_value / .child_number 
 V$SQLAREA.address / .hash_value 
 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_ACTIVE 


© Copyright SS64.com 1999-2014
Some rights reserved