Home Oracle Commands v$ Performance views
Oracle Data Dictionary

V$SQL_WORKAREA_ACTIVE

Data Dictionary View

Columns
   ___________________________
 
   WORKAREA_ADDRESS
   OPERATION_TYPE
   OPERATION_ID
   POLICY
   SID
   QCINST_ID
   QCSID
   ACTIVE_TIME
   WORK_AREA_SIZE
   EXPECTED_SIZE
   ACTUAL_MEM_USED
   MAX_MEM_USED
   NUMBER_PASSES
   TEMPSEG_SIZE
   TABLESPACE
   SEGRFNO#
   SEGBLK#

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 



Simon Sheppard
SS64.com