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!

Finding the Unix PID of a sqlplus connection by the user

orausernFeb 10 2009 — edited Feb 10 2009
Hi,

I want to find at the OS level the process id when a user connects from his machine via sqlplus, is there a way I can do it? - I read that it can be got by combining v$session with v$process, but I still don't know the exact query.

Thanks
NIrav
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 10 2009
Added on Feb 10 2009
5 comments
1,438 views