Re: inactive users how find

On Jun 13, 2:18 pm, "krzys" <krzy..._at_buziaczek.pl> wrote:
> yes thats right but death logins that means that the account was used
> probably one year ago but now account is unused - the preson whos used this
> account is absence
>
> km
>
> "Brian Peasland" <d..._at_nospam.peasland.net> wrote in message
>
> news:4670337f$0$16379$88260bb3_at_free.teranews.com...
>
>
>
> > fitzjarr..._at_cox.net wrote:
> >> 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
>
> > To the OP: you could also implement a profile to automatically kill a
> > session that is idle too long.
>
> > HTH,
> > Brian
>
> > --
> > ===================================================================
>
> > Brian Peasland
> > d..._at_nospam.peasland.net
> >http://www.peasland.net
>
> > Remove the "nospam." from the email address to email me.
>
> > "I can give it to you cheap, quick, and good.
> > Now pick two out of the three" - Unknown
>
> > --
> > Posted via a free Usenet account fromhttp://www.teranews.com- Hide quoted text -
>
> - Show quoted text -

You really need to lock these accounts so they can't be used.

David Fitzjarrell Received on Wed Jun 13 2007 - 14:53:59 CDT