this is what I did when in encountered this issue a long time ago Issue below query and grab sid and serial#.select s.sid, username, program, module, action, logon_time, l.* from v$session s, v$enqueue_lock l where l.sid = s.sid and l.type = 'CF' and l.id1 = 0 and l.id2 = 2;
From v$session, find PADDR value i.e. process address. Match above PADDR with v$process ADDR and get SPID. Use ps -ef to find SPID and kill it. (or wait for it to finish if you can) Issue query in step 1 to make sure lock is gone See here for more details Note:145619.1 -- //www.freelists.org/webpage/oracle-l