Re: Inactive sessions in Oracle

From: <bdbafh_at_gmail.com>
Date: 17 Aug 2006 09:03:02 -0700
Message-ID: <1155830582.313245.131920@p79g2000cwp.googlegroups.com>

aone1504_at_yahoo.com wrote:
> 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.

Possible solutions depend upon properly describing your environment, e.g.:

oracle edition, version and major patchsets applied operating system

-bdbafh Received on Thu Aug 17 2006 - 11:03:02 CDT