最好是找进程如ps 或v$process.PGA_USED_MEM，而不是SQL,  也可参考，  

SELECT
inst_id
, sid
, qcinst_id
, qcsid
, sql_id
-- , sql_exec_start -- 11g+
, operation_type wrka_operation_type
, operation_id plan_line
, policy
, ROUND(active_time/1000000,1) active_sec
, actual_mem_used
, max_mem_used
, work_area_size
, number_passes
, tempseg_size
, tablespace
FROM
gv$sql_workarea_active
WHERE
&1
ORDER BY
sid
, sql_hash_value
, operation_id
/