My Oracle Support Banner

How To Configure v$session Parameters For J2EE Application Using a Connection Pool (Doc ID 459103.1)

Last updated on JULY 20, 2018

Applies to:

Oracle Containers for J2EE - Version 10.1.3.0.0 to 10.1.3.5.0 [Release AS10gR3]
Information in this document applies to any platform.

Goal

The requirement addressed in this article is how to configure the JDBC connection in the Oracle Application Server connection pool to have custom values for the v$session parameters.
For example, v$session.program can take the value of 'iAS connection pool', rather than the default JDBC value.

This requirement can easily be accomplished from the application code by using the JDBC driver parameters, but it is also possible to accomplish this from the connection pool. This allows different applications using the same connection pool to have the same v$session parameter values.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.