DBA Hub

📋Steps in this guide1/1

Get os pid from 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;

oracle configurationintermediate
by OracleDba
13 views
1

Get os pid from sid

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
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;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!