SessionHomogeneous database parameter
Description
Authenicates
all sessions in a session pool with the user name and password in effect
when the session pool was created.
Controls
-
ORA Oracle 11g
Syntax
|
1 |
SessionHomogeneous =<span>value</span> |
|
Parameter |
Description |
|---|---|
|
value |
Specifies restrictions on authentication
|
Default
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',<br>  SessionHomogeneous='Yes'"