Identify database SID based on OS Process ID
Posted by Superadmin on June 25 2022 07:25:25

Identify database SID based on OS Process ID

 

 

col sid format 999999
col username format a20
col osuser format a15
select b.spid,a.sid, a.serial#,a.username, a.osuser
from v$session a, v$process b
where a.paddr= b.addr
and b.spid='&spid'
order by b.spid;