column sql_id format a15
column segtype format a20
column CONTENTS format a12
column machine format a20
column TBS_NAME format a15
column username format a16
column status format a8
column sid format 9999
column LCET format 9999
set linesize 300
set pagesize 30000

SELECT se.username username, se.SID sid, se.status status, se.sql_id,se.machine machine,
su.TABLESPACE TBS_NAME,su.segtype,  su.CONTENTS CONTENTS
--, se.logon_time LG
,se.last_call_et LCET, trunc(SEGBLK#*8/1024/1024) GB_INIT, su.blocks*8/1024 MB
FROM v$session se, v$sort_usage su
WHERE se.saddr=su.session_addr
and se.username like upper('&1')
order by se.username,se.machine;

SELECT se.username username, se.SID sid, se.status status, se.sql_id,se.machine machine,
su.TABLESPACE TBS_NAME,su.segtype,  su.CONTENTS CONTENTS
--, se.logon_time LG
,se.last_call_et LCET, trunc(SEGBLK#*8/1024/1024) GB_INIT, su.blocks*8/1024 MB
FROM v$session se, v$sort_usage su
WHERE se.saddr=su.session_addr
and su.TABLESPACE like upper('&2')
order by se.username,se.machine;
