Step By Step Remove Oracle Table Lock

All your query should be done using sys user or system user, after that you need to find Session SID with below query :


SQL> SELECT SESSION_ID
  2  FROM DBA_DML_LOCKS
  3  WHERE NAME = 'EMP_INFORMATION';

Where EMP_INFORMATION is Table_name

Output :

SID
___
424

Next step it's talking about How to find Serial# :


SELECT SID,SERIAL#
FROM V$SESSION
WHERE SID IN (SELECT SESSION_ID
FROM DBA_DML_LOCKS
WHERE NAME = 'EMP_INFORMATION')
Output :

SID                SERIAL#
----                 -------
424                 1103
Use Alter system To kill this session :
ALTER SYSTEM KILL SESSION 'SID,SERIALl#';

Thank you
Osama mustafa





Comments

Post a Comment

Popular posts from this blog

Connection refused; No available router to destination On Weblogic Node Manager Log

How to change SGA in Oracle Rac

SGA_MAX_SIZE & SGA_TARGET / MEMORY_TARGET & MEMORY_MAX_TARGET