Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: inactive users how find

Re: inactive users how find

From: <fitzjarrell_at_cox.net>
Date: Wed, 13 Jun 2007 11:32:58 -0700
Message-ID: <1181759578.673679.15610@j4g2000prf.googlegroups.com>


On Jun 13, 1:17 pm, "krzys" <krzy..._at_buziaczek.pl> wrote:
> i have a question
> how can i find inactive users in oracle 81741.
> i have many account with "death" login and i need to remove this accounts
> how do it?

I am not certain what you mean by "death" login, however v$session lists every active and inactive session to the database:

select username, sid, serial#, status
from v$session
where username is not null;

This should give you a script, when you spool the output to a file, to kill idle/inactive sessions:

select 'alter system kill session '''||sid||','||serial#||''';' from v$session
where status = 'INACTIVE';

I would thoroughly investigate every suspect session before you kill it.

David Fitzjarrell Received on Wed Jun 13 2007 - 13:32:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US