Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

To find out SID from PID

ramya3250Jan 5 2015 — edited Jan 6 2015

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 3 2015
Added on Jan 5 2015
6 comments
24,022 views