osipd Archives - DBACLASS https://dbaclass.com/article-tag/osipd/ database administration Thu, 20 Jul 2017 12:02:11 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.5 Get ospid from sid https://dbaclass.com/article/get-ospid-sid/ https://dbaclass.com/article/get-ospid-sid/#respond Thu, 20 Jul 2017 11:58:57 +0000 http://dbaclass.com/?post_type=article&p=3112 Below is the script to find the os server process id of a SID. set lines 123 col USERNAME for a15 col OSUSER for a8 col MACHINE for a15 col PROGRAM for a20 select b.spid, a.username, a.program , a.osuser ,a.machine, a.sid, a.serial#, a.status from gv$session a, gv$process b where addr=paddr(+) and sid=&sid; SEE ALSO – […]

The post Get ospid from sid appeared first on DBACLASS.

]]> Below is the script to find the os server process id of a SID.

set lines 123 
col USERNAME for a15 
col OSUSER for a8 
col MACHINE for a15 
col PROGRAM for a20 
select b.spid, a.username, a.program , a.osuser ,a.machine, a.sid, a.serial#, a.status from gv$session a, gv$process b 
where addr=paddr(+) and sid=&sid;

SEE ALSO – Get sid from ospid

The post Get ospid from sid appeared first on DBACLASS.

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