Database profile dialog box changes for the ORA driver

Pooling parameters

The database profile dialog box for an Oracle 11g connection includes a Pooling tab that lets you select the following pooling parameters:

Pooling parameter	Description
Pooling Type	You can select Session Pooling, Connection Pooling, or None (default). Sets the Pooling DBParm.
Runtime Connection Load Balancing	This check box is selected by default. It is ignored when you select Connection Pooling or None for the Pooling Type. Sets the RTConnBalancing DBParm.
Homogeneous Session	This check box is not selected by default and is valid for session pooling only. If selected, all sessions in the pool are authenticated with the PoolCreator and PoolPwd DBParm parameters when these are provided. The user name and password in later connection requests are ignored. Proxy sessions cannot be created in homogeneous session mode. Sets the SessionHomogeneous DBParm.
Minimum Number of Sessions	Integer for the minimum number of database connection sessions; value is 1 by default. Sets the CSMin DBParm. This value is ignored when the SessionHomogeneous DBParm is set to false.
Maximum Number of Sessions	Integer for the maximum number of database connection sessions; value is 100 by default. Sets the CSMax DBParm.
Increment	Integer for database connection increments per session; value is 1 by default. Sets the CSIncr DBParm. This value is ignored when the SessionHomogeneous DBParm is set to false.
Pool Creator	User name used to create the connection or session pool when the pool is not already created. Sets the PoolCreator DBParm to a string for the user name prior to the database connection. If you do not provide a value for the PoolCreator DBParm, the Transaction object’s LogID and LogPass properties are used to create the pooling.
Password	Password used to create the connection or session pool when the pool is not already created. Sets the PoolPwd DBParm to a string for the password for the pool creator.

Additional parameters for Oracle 11g support

Besides the pooling parameters, other database parameters provide additional support for Oracle 11g database connections. These are described in the following table:

Additional parameters for Oracle 11g support	Database profile setup tab page	Description
Application Driver Name (available for ORA driver only)	System	Allows you to set your own client driver name for diagnostic purposes. Sets the AppDriverName DPBARM.
Number of Oracle Statements Cached (supported by the O10 and ORA drivers)	Transaction	The number of statements (0 by default) you can cache for each session. Must be set to a nonzero value to use with the Oracle Client Cache. Sets the StatementCache DBParm.
Connect As (supported by all available Oracle drivers, but allows entry of an end user name for the ORA driver only)	Connection	Editable drop-down list where you can enter an end user if you are using proxy authentication, or select the DEFAULT, SYSOPER, or SYSDBA user names. Sets the ConnectAs DBParm. You cannot use connection or session pooling if you set the ConnectAs DBParm to SYSDBA or SYSOPER.