How to Kill The Toad / Oracle session?
Why/ When we want to Kill trhe seesion?
Whenever we Procedure taking too much time to compile and we want to close the session or cancle the compliation we need to kill the session.
If we need the PC Name Based Query ::
select * from v$session where TERMINAL ='
Query for when we know the Object Name and we need to close the session based upon Object::
SELECT * FROM v$session WHERE SID IN (SELECT UNIQUE SID FROM v$access WHERE OBJECT='&OBJECT_NAME');
OR you may use below query and output of below query will give ready made statements to kill these locks and you can directly use it…
SELECT 'alter system kill session '''||SID||','||serial#||''';'
WHERE TERMINAL ='prashku4'
and SID IN (SELECT UNIQUE SID
select * from v$access
alter system kill session '8542,2456258';
alter system kill session '3528,8695162';