CSMin
database parameter
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
|
1 |
CSMin =value |
|
Parameter |
Description |
|---|---|
|
value |
Specifies the minimum number of database |
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:
1my_trans.dbparm="pooling='connection',csmin = 5"
See also