Search notes:
v$sql_workarea_active
See also
Oracle Dynamic Performance Views
Index