select SID, SERIAL#,substr(USERNAME,1,13) USERNAME,STATUS,substr(OSUSER,1,11) OSUSER,
        substr(MACHINE,1,20) MACHINE, -- TERMINAL,
	logon_time,last_call_et
from v$session
--where username is not null
order by username,machine,terminal
/
