Re: Killing and releasing Inactive session

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

https://gavinsoorma.com/2009/06/using-the-10g-resource-manager-to-manage-inactive-sessions/

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

> Steve
>
> Can you share some example with Resource Manager
>
> Tx
> Sanjay
>
> 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
>
> Thanks
> Sanjay
>
>

--
http://www.freelists.org/webpage/oracle-l