Scott,

It might help:

select 'alter system kill session ''' || SID || ',' || SERIAL# || ''' ;'
from v$session
where status='INACTIVE' and username not in ('SYS','SYSTEM') and username
is
NOT NULL;

Regards,

Bruno




"Adams Scott D.
- G6 "
<oracledba-ezmlms To
hield-x88409957.x "LazyDBA Discussion"
[Email Address Removed] <[Email address protected]
A.com> cc

02/11/2005 03:37 Subject
PM kill session










Is there a way to kill multiple sessions at once?



Scott D. Adams

Database Administrator





--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html





Oracle LazyDBA home page