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