Re: inactive users how find

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 13 Jun 2007 14:21:06 -0700
Message-ID: <1181769664.932121@bubbleator.drizzle.com>

krzys 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" <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

Vladimir's advice is the best. Alter the default profile to lock accounts then just drop locked accounts. There are demos in Morgan's Library at www.psoug.org under PROFILES but here's the basics.

ALTER SYSTEM SET resource_limit=TRUE SCOPE=BOTH;

ALTER PROFILE developer LIMIT password_lifetime 60;

SELECT username, lock_date
FROM dba_users;

Be sure you do not drop intentionally locked administrative accounts such as OUTLN and MDSYS.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Wed Jun 13 2007 - 16:21:06 CDT