News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

Identify OS process ID based on database SID

  • Posted by Gavin Soorma
  • On June 29, 2009
  • 0 Comments
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;
 7

0 Comments

Leave Reply

Your email address will not be published. Required fields are marked *