How To Configure v$session Parameters For J2EE Application Using a Connection Pool
(Doc ID 459103.1)
Last updated on JULY 13, 2022
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.
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document