selectsql_id, count(*) from dba_hist_active_sess_history
where event = 'direct path write temp'
group by sql_id order by count(*) desc;
SELECT * FROM dba_hist_active_sess_history WHERE sql_ID='20kf4wupd3qs0'
select * from dba_hist_sqltext where sql_id ='20kf4wupd3qs0'