Skip to Main Content
Forums

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!

v$session and v$process

happy10319Oct 26 2009 — edited Apr 8 2010
Hi,
how to combine v$session and v$process in order to find the spid of a sqlplus session connected with sys as sysdba ?

Using the follownig I see all with the same Windows user :


select spid , username from v$process


Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 6 2010
Added on Oct 26 2009
#general-database-discussions
5 comments
21,429 views