Connection pool and session identifier

I'm currently involved in a project requring the customization of an existing application heavily accessing an Oracle database (version 9i). The applications connects to Oracle via a connection pool. I would like to monitor the behavior of the application from the point of view of usage of Oracle resource (physical read operations, logical blocks used, cpu used ...) via the session information available in dynamic performance view such as v$mystat, v_$sesstat, v_$session, but while I know that with Oracle connection pool the connection used by an application changes at every database access, I do not know if the session identifier remains the same. If also the session idenitfier changes each time, it does not have any meaning to collect information via the above view will be meanigless.

Thanks

Enrico Received on Tue Feb 20 2007 - 17:10:06 CST