CSMax
database parameter
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
|
1 |
CSMax =value |
|
Parameter |
Description |
|---|---|
|
value |
Specifies the maximum number of database |
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:
1my_trans.dbparm="pooling='connection',csmax = 15"
See also