Re: Killing and releasing Inactive session
From: Sanjay Mishra <"Sanjay>
Date: Tue, 17 Apr 2018 21:33:46 +0000 (UTC)
Message-ID: <1240499450.1019309.1524000826116_at_mail.yahoo.com>
Date: Tue, 17 Apr 2018 21:33:46 +0000 (UTC)
Message-ID: <1240499450.1019309.1524000826116_at_mail.yahoo.com>
Steve
On Tuesday, April 17, 2018, 4:51:09 PM EDT, Steve Harville <steve.harville_at_gmail.com> wrote:
Resource manager works. Keep in mind some applications can't handle having their sessions closed.
On Tue, Apr 17, 2018 at 12:02 PM Sanjay Mishra <dmarc-noreply_at_freelists.org> wrote:
What is the best way to remove Inactive session from the database so that Max connection is not reached. Using Idle time only mark them inactive or Sniped but willnot be removed by PMON. Is this the best approach to use idle_time and DCD to handle it. Environment is 12cR1
ThanksSanjay
Can you share some example with Resource Manager
TxSanjay
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Apr 17 2018 - 23:33:46 CEST