19_Top_Query_Memory.sql

19_Top_Query_Memory.sql

col sql_text format a45 heading 'Current|Statement' word

select c.sql_text, w.operation_type, top_ten.wasize 

From (Select *

       From (Select workarea_address, actual_mem_used wasize

             from v$sql_workarea_active

             Order by actual_mem_used)

       Where ROWNUM <=10) top_ten,

       v$sql_workarea w,

       v$sql c 

Where w.workarea_address=top_ten.workarea_address

         And c.address=w.address

         And c.child_number = w.child_number

         And c.hash_value=w.hash_value

/