Kill Oracle Sessions
select inst_id,sid,serial# from gv$session where username='DBSNMP';
INST_ID SID SERIAL#
---------- ---------- ----------
1 282 730
1 284 18914
1 305 28470
alter system kill session '282,730,@1';
INST_ID SID SERIAL#
---------- ---------- ----------
1 282 730
1 284 18914
1 305 28470
alter system kill session '282,730,@1';
0 comments:
Post a Comment