select sql_id, operation_type, max_tempseg_size from v$sql_workarea where max_tempseg_size > 10000000 order by max_tempseg_size;

select * from v$sqlarea where sql_id = ...