Specifies the minimum number of database connections in a connection or session pool.
ORA Oracle 11g and Oracle 9.2 or later databases
CSMin =value
Parameter |
Description |
|---|---|
value |
Specifies the minimum number of database connections in a connection or session pool. |
1
This value is ignored when the SessionHomogeneous DBParm is set to false.
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"
