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

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 10 2009

Added on Feb 10 2009

#general-database-discussions

5 comments

1,438 views