locked
.net 2.0 framework creating hundreds of connections to Oracle RRS feed

  • Question

  • User-1796913407 posted

    We have a website that over the most recent months has began to randomly create hundreds of connections to our Oracle database. The website should create Oracle connections in order to operate, however it should not be flooding Oracle with connections.  The website is programmed .net 2.0 framework running on a IIS 6 with Windows server 2008 32 bit.  Most of the code is written in .asp.

    It seems as though the connection pool is sending out request to Oracle to grab maybe 25 connections at a time, which is fine. However it randomly sometimes just starts grabbing 100-200+ connections back to back very quickly and then it just abandons the connections and leaves them open. We can go from 100 connections in Oracle to up to 500 to 600 easily, and this cripples the DB.

    We have a procedure in Oracle which is killing the connections, however we can't hardly kill them fast enough sometimes.  

    Can anyone help me begin to troubleshoot what may be going on?

    Friday, May 6, 2016 3:51 PM

Answers

  • User-2064283741 posted

    This looks like a code issue where you are opening your Oracle connections and not closing them correctly.

    You need to walk-through your code to see where this is occurring.

    • Marked as answer by Anonymous Tuesday, September 28, 2021 12:00 AM
    Friday, May 6, 2016 11:41 PM

All replies

  • User-663891294 posted

    Not an Oracle expert myself, but are the connection Dispose methods being called from your applications?

    Friday, May 6, 2016 9:28 PM
  • User-2064283741 posted

    This looks like a code issue where you are opening your Oracle connections and not closing them correctly.

    You need to walk-through your code to see where this is occurring.

    • Marked as answer by Anonymous Tuesday, September 28, 2021 12:00 AM
    Friday, May 6, 2016 11:41 PM