Session pooling using Direct Oracle Access components

[Helene]

We are considering using session pooling, with pooltype ptOracle. We don't find the necessary information in the manual, and wonder how this actually works. For instance, in the Oracle documentation there is a distinction between connection pooling and session pooling, seehttp://download.oracle.com/docs/cd/B28359_01/appdev.111/b28395/oci09adv.htm#insertedID4Will the ptOracle pooltype mean that we actually use the OCI connection pool, the OCI session pool, or something else?

Any help will be greatly appreciated

Is there any way we can monitor the actual usage of the connection pool, so that we can determine wheter it is beneficial or not in terms of performance vs resource usae. Can we actually see the usage of the session pool from Oracle Monitor?

 

[Marco Kalter]

The ptOracle session pool uses the OCI Session pooling mechanism.

There is no built-in functionality to monitor the pool resource usage or performance statistics. You would have to use an external DBA tool for this.

 

[Helene]

Thanks for the quick answer

We just asked our Oracle DBA about tools for monitoring this, and he didn't know of any tool for client-side monitoring (other than Oracle Monitor...).

We would be very interested to know if you have any knowledge of such a tool

 

[Marco Kalter]

I think you will need to monitor this on the server. The goal is to reduce the amount of logon/logoffs and the resource usage that would result from initializing these sessions. That should be "monitorable" if you can run your application with and without session pooling.