Set linesize 200
column USERNAME format a10
column MACHINE format a20
column OSUSER format a10
column SERVICE_NAME format a35
SELECT
a.sid,a.serial#,b.spid,b.pid,a.username,a.osuser,a.machine
FROM
v$session a,v$process b
WHERE
a.username IS NOT NULL
AND
a.paddr=b.addr
Order by a.sid,a.username;
