Select a.sid, serial#, a.osuser, a.machine, c.SQL_FULLTEXT, a.terminal, b.SEGTYPE, a.program, a.USERNAME, a.status, round((b.blocks * 8192) / 1024 / 1024, 2) "Tam TEMP", c.last_load_time from v$sort_usage b, v$session a, V$SQLAREA c where a.saddr = b.SESSION_ADDR and c.hash_value = b.SQLHASH order by c.last_load_time