Windows Oracle Data Access Components (MOSC)

MOSC Banner

mapping between process column of v$Session with client with tid

edited Aug 20, 2013 6:47AM in Windows Oracle Data Access Components (MOSC) 1 commentAnswered
I was looking into the process column of the v$session of the connections created by a connection pool for a .Net application using odp.net. It was surprising to me is that I was not able to map all values in the process column (pid:tid)  with the existing threads. Basically, pid was same for all connections in the connection pool but tid was different but then all of these tids were not existing.
I want to understand how process column of v$session gets managed in the case of connection pool? Is it something that whichever threads have initiated the connections in the connection pool, it stores their thread number in the process column but then even after that thread has been removed, the connection in the connection pool persists and it keeps serving incoming requests.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center