查看哪个sql使用临时段比较多

参考《oracle性能优化实务》

select sql_id,operation_type as op, operation_id as id,
  round(estimated_optimal_size/1024/1024,2) as e_opt,  
  round(estimated_onepass_size/1024/1024,2) as e_one,
  round(last_memory_used/1024/1024,2) as l_mem,
  Last_execution as last,
  total_executions as tot, optimal_executions as opt,
  onepass_executions as one, 
  multipasses_executions as mult,
  round(active_time/1000000,2) as sec,   
  round(max_tempseg_size/1024/1024,2) as tmp_m, 
  round(last_tempseg_size/1024/1024,2) as tmp_L
from v$sql_workarea 
where 
  max_tempseg_size is not null 
order by max_tempseg_size desc;