How can I know SID associated with PID. Is SPID is different from PID. In what cases I see SID for PID. Once I have SID I can monitor from OEM.
I using the following query which gives results sometimes and sometimes don't. What does it indicates ?
select b.spid,a.sid, a.serial#,a.username, a.osuser
from v$session a, v$process b
where a.paddr= b.addr
and B.SPID='&spid'
order by b.spid;
Thanks