This content has been marked as final. Show 7 replies
Find the session which is locking and kill it
s1.username || '@' || s1.machine
|| ' ( SID,S#=' || s1.sid || ',' || s1.serial# || ' ) is blocking '
|| s2.username || '@' || s2.machine
|| ' ( SID,S#=' || s2.sid || ',' || s2.serial# || ' )'
s1.sid = l1.sid
and s2.sid = l2.sid
and l1.BLOCK = 1
and l2.request > 0
and l1.id1 = l2.id1
and l2.id2 = l2.id2;
For Interest - Oracle Support provided the solution.
Use Process Explorer that can be downloaded from: http://technet.microsoft.com/en-us/sysinternals
Then read the metalink document to configure and find the offending DLL or File Handle and close it..
HOWTO: Use Process Explorer to Obtain a List of DLLs Loaded by a Windows Process (Doc ID 416318.1)