ospid Archives - DBACLASS https://dbaclass.com/article-tag/ospid/ database administration Thu, 20 Jul 2017 12:01:40 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.5 Get sid from ospid https://dbaclass.com/article/get-sid-ospid/ https://dbaclass.com/article/get-sid-ospid/#comments Thu, 20 Jul 2017 12:01:40 +0000 http://dbaclass.com/?post_type=article&p=3114 Below is the script to find the respective sid of an server proccess 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; SEE ALSO – Get ospid from sid

The post Get sid from ospid appeared first on DBACLASS.

]]> Below is the script to find the respective sid of an server proccess 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;

SEE ALSO – Get ospid from sid

The post Get sid from ospid appeared first on DBACLASS.

]]> https://dbaclass.com/article/get-sid-ospid/feed/ 2