Clearing Hanged Session

[dxb]

HI

How can I clear hanged session from the database without restating the instance. ( I AM USING ORACLE 8.1.7)


select machine,count(*) from v$session group by ,machine;

[SANJAY_G]

alter system kill session 'SID, SERIAL#';

[dxb]

thank you very much SANJAY_G


I did it and the status of the hanged sessions changed from INACTIVE to KILLED and its being deleted gradually by the system.

[engiri]

The query will yield the
blocking session.

select ''''||a.sid||','||a.serial#||'''' to_kill,
a.username,a.machine, a.lockwait,a.osuser,
a.program,b.owner,b.object_name,c.locked_mode
from v$locked_object c, all_objects b, v$session a
where b.object_id = c.object_id and a.sid = c.session_id;


with the sid and serial number you can delete that
user after verifying the username,machine name users query.

Regards
Giri