set linesize 200
set pagesize 999
col username format a20
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
select sysdate from dual;
select * from (
select USERNAME,SESSION_NUM,SQL_ID,TABLESPACE,SEGTYPE,BLOCKS*8192/1024/1024||' MB' as MB from v$sort_usage order by 6 desc
)
where rownum < 11;
set pagesize 999
col username format a20
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
select sysdate from dual;
select * from (
select USERNAME,SESSION_NUM,SQL_ID,TABLESPACE,SEGTYPE,BLOCKS*8192/1024/1024||' MB' as MB from v$sort_usage order by 6 desc
)
where rownum < 11;