Oracle DB connections increases after an IIS recycle

61 views Asked by At

Web applications double in Oracle database connections after the IIS is recycled on the Windows 2019 web server. This is occurring during off-hours with nobody on the system. It's a VB.net application using ODP.net to connect to the database. How can I determine what is creating these numerous database connections? Is there a monitoring tool that will help capture the issue?

I set the expire_time in the sqlnet.ora for the database to terminate the connections as well as setup profiles to terminate idle connections however that we not prevent the vast amount of connections after an IIS recycle.

0

There are 0 answers