Description
Specifies the minimum 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
CSMin =value
|
Parameter |
Description |
|---|---|
|
value |
Specifies the minimum number of database connections in a connection or session pool. |
Default value
1
Usage
This value is ignored when the SessionHomogeneous DBParm is set to false.
Examples
The following code keeps a minimum of 5 database connections open in a connection pool:
-
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 5 in the Minimum Number of Sessions text box on the same page.
-
Application
Type the following in code:
my_trans.dbparm="pooling='connection',csmin = 5"
See also
