select S.* from gv$session S, gv$process P
where spid=2858
and S.paddr=P.addr
;