Description
Specifies the maximum number of database connections in a connection or session pool.
Applies to
ORA Oracle (for 11g and later), O10 Oracle 10g, and Oracle 9.2 databases
Syntax
CSMax =value
|
Parameter |
Description |
|---|---|
|
value |
Specifies the maximum number of database connections in a connection or session pool. |
Default value
100
Usage
This value is ignored when the SessionHomogeneous DBParm is set to false.
Examples
The following example limits the number of database connections in a connection pool to 15:
-
Database profile
Select Connection Pooling from the Pooling Type drop-down list on the Pooling page in the Database Profile Setup dialog box, and type 15 in the Maximum Number of Sessions text box on the same page.
-
Application
Type the following in code:
my_trans.dbparm="pooling='connection',csmax = 15"
See also
