SET echo off
SET long 50000
SET pages 1000
SET lines 150
COL username format a15
COL osuser format a20
COL cmd format a200

SELECT P.SPID, S.SID, S.SERIAL#
FROM gV$PROCESS P, gV$SESSION S
WHERE P.ADDR = S.PADDR
AND S.SID =1604;


SELECT  
	s.sid || ',
	' || s.serial# "SID/SERIAL",
	s.username,
	s.osuser,
	p.spid "OS PID",
	s.program
FROM
     v$session s,v$process p
WHERE
     s.paddr = p.addr
order by
	to_number(p.spid);