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,
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-lReceived on Thu Feb 17 2011 - 13:20:36 CST