How to get hostpid:

SELECT P.SPID, P.PID, S.SID, S.SERIAL#, S.OSUSER
FROM V$PROCESS P, V$SESSION S
WHERE S.PADDR = P.ADDR
ORDER BY S.OSUSER
/