Specifies the type of pooling to use with an Oracle database.
ORA Oracle 11g
Pooling =value
Parameter |
Description |
---|---|
value |
Specifies whether to use pooling, and if so, what kind of pooling. Values are:
|
No pooling.
With the ORA driver you specify the type of pooling you want with the Pooling DBParm. The O90 and O10 database drivers that you can use in InfoMaker to connect to the 9.x and 10.x versions of the Oracle DBMS support connection pooling with the DBParm parameter CNNPool. For backward compatibility purposes, the CNNPool parameter is also supported by the ORA driver. However, if you set the Pooling parameter with the ORA driver, the CNNPool parameter is ignored.
If you are using connection or session pooling, the proxy user name is the connection or session pooling creator (which you can provide in the PoolCreator and PoolPwd DBParm parameters), and the Transaction object’s LogID is ignored.
If you select session pooling, you can enter a value for the SessionHomogeneous DBParm to authenticate all sessions in the pool with the user name and password in effect when the session pool was created. No proxy session can be created if pooling is set to homogeneous session mode.
To set up a connection pool, select Connection Pooling
from the Pooling Type drop-down list on the Pooling page in the
Database Profile Setup dialog box, type Scott
in
the Pool Creator text box, and Scott’s password in the
Password text box on the same page.