set termout off feedback off verify off linesize 200 pages 100

select snap_id,name,value/1024/1024 TEMP_MB_USED from stats$sysstat where name ='temp space allocated (bytes)' and instance_number=&1 and snap_id between &2 and &3;
/