02 Aralık 2009

Killing connected user sessions from an Oracle DB

Killing connected user sessions from an Oracle DB
select sid,serial# from v$session;

(
Use following in a RAC environment:
select sid,serial# from gv$session;
)
Output is something like this:
----- -----
xxx yyy


then for each row run:
alter system kill session 'xxx,yyy' immediate;

Hiç yorum yok: