Re: inactive users how find

From: <fitzjarrell_at_cox.net>
Date: Wed, 13 Jun 2007 11:52:12 -0700
Message-ID: <1181760732.302856.114550@i13g2000prf.googlegroups.com>

On Jun 13, 1:36 pm, sybra..._at_hccnet.nl wrote:
> On Wed, 13 Jun 2007 11:32:58 -0700, "fitzjarr..._at_cox.net"
>
> <fitzjarr..._at_cox.net> wrote:
> >I would thoroughly investigate every suspect session before you kill
> >it.
>
> LAST_CALL_ET contains the number of seconds the session has been
> inactive. Inactive means: not executing a sql statement.
> LAST_CALL_ET is reset every time a sql statement is executed.
>
> --
> Sybrand Bakker
> Senior Oracle DBA

I wasn't certain what columns exist in the 8.1.7.4 version of V $SESSION. Such information certainly would help in deciding which sessions were truly idle.

David Fitzjarrell Received on Wed Jun 13 2007 - 13:52:12 CDT