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;
Kaydol:
Kayıt Yorumları (Atom)
Hiç yorum yok:
Yorum Gönder