V$Transaction entry

From: Petr Novak <Petr.Novak_at_trivadis.com>
Date: Thu, 17 Feb 2011 19:20:36 +0000
Message-ID: <09011014EB621E4CBC2536B62A1B640702447D_at_SMXC001.trivadis.com>



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

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 17 2011 - 13:20:36 CST

Original text of this message