Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using Oracle OCI Connection Pooling with vb.NET

437871Aug 8 2005 — edited Jan 4 2008
We 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 1 2008
Added on Aug 8 2005
1 comment
5,654 views