column username format a11;
column osuser format a10;
column program format a35;
select username,osuser,terminal,program,status from v$session
where username is not null;
