Re: Killing and releasing Inactive session
From: Steve Harville <steve.harville_at_gmail.com>
Date: Tue, 17 Apr 2018 20:50:07 +0000
Message-ID: <CAGd4=DTJg9r3trYgSEMtPJCU8r34rYhJiw9s7DjvToCcbM6cJg_at_mail.gmail.com>
Date: Tue, 17 Apr 2018 20:50:07 +0000
Message-ID: <CAGd4=DTJg9r3trYgSEMtPJCU8r34rYhJiw9s7DjvToCcbM6cJg_at_mail.gmail.com>
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
>
> Thanks
> Sanjay
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Apr 17 2018 - 22:50:07 CEST