col sid format 999999 col username format a20 col osuser format a15 select a.sid, a.serial#,a.username, a.osuser, b.spid from v$session a, v$process b where a.paddr= b.addr and a.sid='&sid' order by a.sid;
The following two tabs change content below.
Gavin Soorma
