Search code examples
asp.netoracleconnection-pooling

how to set Oracle connection pool size?


We have been getting this Oracle connection pool exception a lot recently for our ASP.NET website. This is the detailed exception message:

Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.

This is our connection string

User ID=user1;password=password1;DATA SOURCE=Datasource1 

Can you tell me how to set max pool size to 1 so that I can debug it on my local?

Another question is: what is the recommended pool size for a website with 10,000 users? and if max pool size is reached, how to fail gracefully?

Thanks a lot!


Solution

  • I have used such connection string to set the connection pool size:

    const string connString = "server=localhost;" +
                                  ....
                                 "Min Pool Size=3;" +
                                 "Max Pool Size=3";
    

    But you don't need to set connection pool size bigger. Such error message I have got when I forget to close connections. Check your code to find places where you open connections, but don't close them. It can help you.