Find SID from Process ID (PID) in Oracle

 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;