SessionHomogeneous
database parameter
Description
Authenticates all sessions in a session pool with the user name
and password in effect when the session pool was created.
Applies to
ORA Oracle (for 11g and later)
Syntax
|
1 |
SessionHomogeneous =value |
|
Parameter |
Description |
|---|---|
|
value |
Specifies restrictions on authentication values for
|
Default value
False, but this value is meaningless if session pooling is not
set.
Usage
When set to True, all sessions in the session pool are
authenticated with the user name and password in effect when the pool
was created. The user name and password in later connection requests are
ignored. Proxy sessions cannot be created in homogeneous session
mode.
Examples
The following example enables homogeneous session pooling:
-
Database profile
Select Session Pooling from the Pooling Type drop-down list on
the Pooling page in the Database Profile Setup dialog box, select
the Homogeneous Session Pooling check box on the same page. -
Application
Type the following in code:
1my_trans.dbparm="Pooling='session', SessionHomogeneous='Yes'"
See also