Re: Inactive sessions in Oracle

From: Bob Jones <email_at_me.not>
Date: Fri, 18 Aug 2006 00:49:33 GMT
Message-ID: <x88Fg.10349$kO3.4949@newssvr12.news.prodigy.com>

<aone1504_at_yahoo.com> wrote in message
news:1155800601.955607.234770_at_74g2000cwt.googlegroups.com...
> We have sessions created in Oracle database for user queries, that
> remain Inactive for long and sometimes they prevent further access to
> the database( we get error message from oracle on further access).
>
> Is it possible to access these sessions (and their attributes like,
> time when the session is created) from Unix Shell script, so that we
> can kill these sessions from O/S level, based on the duration of
> inactivity.
>
> Thanx.
>

Why not set idle timeout in Oracle? Received on Thu Aug 17 2006 - 19:49:33 CDT