Re: Killing and releasing Inactive session

From: Sanjay Mishra <"Sanjay>
Date: Wed, 18 Apr 2018 13:51:27 +0000 (UTC)
Message-ID: <>

 Thanks Steve

    On Tuesday, April 17, 2018, 7:49:21 PM EDT, Steve Harville <> wrote:  

 I found a blog post about it. Enterprise Manager has a GUI interface that does the same thing.

On Tue, Apr 17, 2018 at 5:33 PM Sanjay Mishra <> wrote:

Can you share some example with Resource Manager TxSanjay

    On Tuesday, April 17, 2018, 4:51:09 PM EDT, Steve Harville <> 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 <> 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      

Received on Wed Apr 18 2018 - 15:51:27 CEST

Original text of this message