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!

How to map the client PID:TID to db connection on the database?

P3Siebel-OracleJun 24 2009 — edited Feb 18 2011
Hi,

We have a multithreaded application and each thread connects to database using the same userID.
How do I identify on the dtabase side which DB connection belongs to which client thread?

I need to uniquely map the client processID:Thread ID to a DB connection.
On Unix I do not see the processID:Thread ID pair in the v$session table process column.
It is only showing the PID.

Any other ways to map the client PID:TID to db connection?

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 18 2011
Added on Jun 24 2009
9 comments
4,005 views