Re: inactive users how find

From: krzys <krzys_m_at_buziaczek.pl>
Date: Wed, 13 Jun 2007 21:18:16 +0200
Message-ID: <f4pftq$co5$1@news.onet.pl>

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" <dba_at_nospam.peasland.net> wrote in message news:4670337f$0$16379$88260bb3_at_free.teranews.com...
> fitzjarrell_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
> dba_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 from http://www.teranews.com
>
Received on Wed Jun 13 2007 - 14:18:16 CDT