Connection Pooling and Inactive Connections
774016May 19 2010 — edited May 19 2010I have some application developers connecting to an 11g database using .NET web applications. They are using OLE DB like in this connection string:
Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;
Unfortunately none of us know much about how OLE DB works. From what I've managed to find out it looks like OLE DB uses connection pooling by default and that the maximum size of the connection pool is 100 by default. Is this correct? If so, how can one change the max size of the pool?
Also, can OLE DB leave Inactive Connections in the database - are these pooled connections that will be reused? Our production dbas don't like these inactive connections and have implemented a kill script that runs every 5 minutes and kills any inactive connections caused by web applications - is this normal practice?
Thanks, Mike