Hallo Mark, there is no such session. From V$LOCKED_OBJECT I get SID 615 which does not exist. Best Regards, Petr Novak ________________________________________ Von: Bobak, Mark [Mark.Bobak@xxxxxxxxxxxx] Gesendet: Donnerstag, 17. Februar 2011 22:02 Bis: Petr Novak; Anjul Cc: oracle-l@xxxxxxxxxxxxx Betreff: RE: V$Transaction entry Hi Petr, So, if you take that row from v$transaction, can you identify the session with the following SQL? select sid,serial# from v$session where taddr in(select addr from v$transaction where <conditions to identify the row in v$transaction that you're interested in>); Then kill the session returned from this query. -Mark -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Petr Novak Sent: Thursday, February 17, 2011 3:44 PM To: Anjul Cc: oracle-l@xxxxxxxxxxxxx Subject: AW: V$Transaction entry Hallo Anjul, there is no row in dba_2pc_pending, only in V$transaction Mit freundlichen Grüssen Petr Novak ________________________________________ Von: Anjul [anjulsahu@xxxxxxxxx] Gesendet: Donnerstag, 17. Februar 2011 20:55 Bis: Petr Novak Cc: oracle-l@xxxxxxxxxxxxx Betreff: Re: V$Transaction entry We had a similar issue in our production environment and we had to bounce the database to clear off those transactions. But recently i learned that we can force other sessions to rollback or commit. For doing that we force any transaction privilege. ROLLBACK FORCE 'transaction_id' ; transaction_id can be fetched from dba_2pc_pending view. documented@/oracle_9i/doc/server.901/a90117/ds_txnma.htm HTH Anjul On Fri, Feb 18, 2011 at 12:50 AM, Petr Novak <Petr.Novak@xxxxxxxxxxxx<mailto:Petr.Novak@xxxxxxxxxxxx>> wrote: Hi, I have following problem: update on table waits for lock (only one row tested) , there is no lock on the table in v$LOCK, analyze table validate structure gets ORA-00054, no rows in db_2pc_pending or pending_sessions , but there is one day old entry in V$TRANSACTION and V$LOCKED_OBJECT shows lock held by nonexistent session. Is there some possibility how to delete this entry from v$transaction without restarting the DB ? with dbms_transaction (I have no rights on it) ? Best Regards, Petr Novak -- //www.freelists.org/webpage/oracle-l -- Anjul Sahu Ph. +917869079958 | Gtalk: anjulsahu Blog: http://anjulsahu.blogspot.com/ Facebook: http://www.facebook.com/anjuls -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l