Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: inactive users how find
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