How to find SID from PID in Oracle Database?
The below query helps in finding the Session ID using Process ID within Oracle Database,
SELECT s.SID,
s.serial#,
s.machine,
s.osuser,
s.terminal,
s.username
FROM v$process P LEFT OUTER JOIN v$session s ON P.addr = s.paddr
WHERE P.spid = 12345;
No comments:
Post a Comment