Using Oracle OCI Connection Pooling with vb.NET
437871Aug 8 2005 — edited Jan 4 2008We are developing a vb.net application to connect to an Oracle database(9i). We are trying to implement Oracle OCI connection pool with Proxy authentication. Is there a way to use the OCI connection pool within .Net? Our Proxy account is app_user, and we want to set our initial and min to 20 and our max to 50. Currently we are using a regular OleDb connection, and our connection string is this.
provider=OraOLEDB.Oracle.1;User ID=userxPassword=******;Proxy User Id=app_user;Proxy Password=******;Initial Limit=20;Min Pool=20;Max Pool=50;Data Source=database;Pooling=true
Want to take this idea and make it an Oracle OCI connection pool. When the user creates a connection pool, he/she will have deticated connections(20) with the remaining connections as whichever pseudo user. We are trying to see this result by executing the following SQL command.
select username,server,module
from v$session
where type !='BACKGROUND'
and username is not null
order by username;
Currently we see the username as a result instead of the Proxy username we would like to see dedicated the rest should be pseudo users under the server column.