How to kill Database session?
Find SID and SERIAL# values from V$Session view (only admin users can access this table like SYSTEM, SYS..) or Admin role privileged users.
select sid,serial# from v$session where status='ACTIVE' and USERNAME=':MYUSER';
Use below command for killing running session.
ALTER SYSTEM KILL SESSION 'sid,serial#';
alter system kill session'368,169';
Note: Be care full while killing sessions in your database and verify SID and Serieal# values before killing.
Find SID and SERIAL# values from V$Session view (only admin users can access this table like SYSTEM, SYS..) or Admin role privileged users.
select sid,serial# from v$session where status='ACTIVE' and USERNAME=':MYUSER';
Use below command for killing running session.
ALTER SYSTEM KILL SESSION 'sid,serial#';
alter system kill session'368,169';
Note: Be care full while killing sessions in your database and verify SID and Serieal# values before killing.
No comments:
Post a Comment