-- name       : who.sql
-- date       : Jul-2001
-- Author     : Pentest Limited
-- Description: Get details of who is logged onto an Oracle database.
-- limitation : need to have select privilege on v_$process and v_$session.
--
-- usage     : SQL> connect username/password @who.sql

col status for a8
col spid for a9
col username for a10
col sid for 9999
col serial# for 999999
col uname for a10
	
select 	s.status,
		p.spid,
		p.username,
		s.sid,
		s.serial#,
		s.username uname
from 		v$process p, 
		v$session s
where 	p.addr=s.paddr
/
exit