How to kill blocking session on object ?
STEP1:
Initially we need to find out blocking session on object
SELECT o.owner, o.object_name, o.object_type, o.last_ddl_time, o.status, l.session_id, l.oracle_username, l.locked_mode
FROM dba_objects o, gv$locked_object l
WHERE o.object_id = l.object_id and o.object_name='EMP';
STEP2:
In order to kill holding session we need to find out serial#:
SQL> select SERIAL# from v$session where SID=890;
STEP3:
Basic syntax to kill session
SQL> alter system kill session 'sid, serial#';
----Nikhil Tatineni--
----Oracle in memory--
STEP1:
Initially we need to find out blocking session on object
SELECT o.owner, o.object_name, o.object_type, o.last_ddl_time, o.status, l.session_id, l.oracle_username, l.locked_mode
FROM dba_objects o, gv$locked_object l
WHERE o.object_id = l.object_id and o.object_name='EMP';
STEP2:
In order to kill holding session we need to find out serial#:
SQL> select SERIAL# from v$session where SID=890;
STEP3:
Basic syntax to kill session
SQL> alter system kill session 'sid, serial#';
----Nikhil Tatineni--
----Oracle in memory--