spool X.tmp;
select USERNAME, COMMAND from v$session
where username Is Not Null
/
spool off;
edit x.tmp