Hi,

We are tying to test a OCI Connection Pool Proxxy Authentication scenario and so far it seems to be working, but we are getting some miscued information from the DB. We are using a .NET (VB.NET) application and we establish a connection to the database using APP_USER as the proxy account. Our Min Pool Size is 1 and our Max Pool Size is 5. Here is how I am testing it after the application has established a connection.

Here is my connection string I use within VB.NET:
myConnectionString1 = "Persist Security Info=False;Proxy User ID=DMIS_APP_USER;Proxy Password=*********;User ID=" & strUser & ";Incr Pool Size=1;Pooling=true;Min Pool Size=1;Max Pool Size=25;Data Source=DMIS;Connection Lifetime=5"

When I query V$SESSION, I see the following:
USERNAME SERVER MODULE LOGON_TIME STATUS
----------------------------------------------------------------------------------------------------------------------
DMISDBA DEDICATED TestPool.exe 8/9/2005 10:38:23 INACTIVE
DMIS_APP_USER DEDICATED TestPool.exe 8/9/2005 10:38:22 INACTIVE
DMIS_APP_USER DEDICATED TestPool.exe 8/9/2005 10:38:19 INACTIVE
DMIS_APP_USER DEDICATED TestPool.exe 8/9/2005 10:38:22 INACTIVE
RANDS DEDICATED TestPool.exe 8/9/2005 10:38:24 INACTIVE
ZEVERSEN DEDICATED TestPool.exe 8/9/2005 10:38:22 INACTIVE

As you can see here, APP_USER has established 3 dedicated connections when it should only have one. The other users should have the value of PSEUDO under the server column. But as you can see it does not.

One thing to note here: It seems like that the application is setting up a connection cache pool. In this case the results when I query V$SESSION are accurate and correct, but I am trying to run a OCI Connection Pool which will eliminate the problem of multiple physical connections to the pool. In OCI Connection Pool I can multiplex the database connections. I would simply like to have one physical connection to the DB with multiple database sessions over it. I can perform this action in Java, but I am pretty sure that in .NET it can be done.

If someone can please answer this for me I would greatly appreciate it.

Raman Gill