Re: How does Oracle database close client connections
From: Stefan Koehler <contact_at_soocs.de>
Date: Fri, 16 Nov 2018 11:19:34 +0100 (CET)
Message-ID: <1563537096.100913.1542363574830_at_ox.hosteurope.de>
Date: Fri, 16 Nov 2018 11:19:34 +0100 (CET)
Message-ID: <1563537096.100913.1542363574830_at_ox.hosteurope.de>
Hello Amir,
seriously you have a more serious issue than the IDLE connections not being ended/closed.
How many cores do you have? I assume that it is less than 400 cores and so you are heavily oversubscribing your CPUs. Define a static connection pool according to your amount of available cores and that's it - anyway no need to worry about the IDLE connections afterwards.
For more information please check out the RWP Learning Library (Videos #13 & #14): https://apexapps.oracle.com/pls/apex/f?p=44785:141:0::NO::P141_PAGE_ID,P141_SECTION_ID:119,870
Best Regards
Stefan Koehler
Independent Oracle performance consultant and researcher
Website: http://www.soocs.de
Twitter: _at_OracleSK
- However, the same load when run in the pre-production environment, it consumes up to 4000 connections and this is a repeatable process. I have been told that IIS is setup the same way in non-production and pre-production environments. The default value of releasing idle connections frequency in IIS is 30 seconds. However, after processing invoices, even though connections established from the IIS VM have INACTIVE status, connections are not getting released in the pre-production environment and I am trying to understand the mechanism around how Oracle database releases connections.
>
> I believe (and I could be wrong) that Oracle does not automatically close INACTIVE connections on its own and this is not the same situation as DCD. Is it possible that even though IIS is trying to shrink the connection pool but Oracle database is not releasing connections? Both non-production and pre-production have same initialization parameters with the only difference being the SGA size.
>
> Any insight will be appreciated.
>
> Thanks,
> Amir
-- http://www.freelists.org/webpage/oracle-l