Connection String Attributes

Attribute - Connection Lifetime
Default value - 0
Description - Maximum life time (in seconds) of the connection

Attribute - Connection Timeout
Default value - 15
Description - Maximum time (in seconds) to wait for a free connection from the pool

Attribute - Data Source
Default value - empty string
Description - Oracle Net Service Name that identifies the database to connect to

Attribute - DBA Privilege
Default value - empty string
Description - Administrative privileges: SYSDBA or SYSOPER

Attribute -Decr Pool Size
Default value - 1
Description - Controls the number of connections that are closed when an excessive amount of established connections are unused

Attribute - Enlist
Default value - true
Description - Enables or disables serviced components to automatically enlist in distributed transactions

Attribute - Incr Pool Size
Default value - 5
Description - Controls the number of connections that are established when all the connections in the pool are used

Attribute - Max Pool Size
Default value - 100
Description - Maximum number of connections in a pool

Attribute - Min Pool Size
Default value - 1
Description - Minimum number of connections in a pool

Attribute - Password
Default value - empty string
Description - Password for the user specified by User Id

Attribute- Persist Security Info
Default value - false
Description - Enables or disables the retrieval of password in the connection string

Attribute - Pooling
Default value - true
Description - Enables or disables connection pooling

Attribute - Proxy User Id
Default value - empty string
Description - User name of the proxy user

Attribute - Proxy Password
Default value - empty string
Description - Password of the proxy user
User Id   empty string Oracle user name

Now we finally get to a Pooling Example.

OracleConnection con = new OracleConnection();
con.ConnectionString = "User Id=scott;Password=tiger;Data Source=oracle;" +
"Min Pool Size=10;Connection Lifetime=120;Connection Timeout=60;" +
"Incr Pool Size=5; Decr Pool Size=2";
con.Open();