V$Transaction entry
- From: Petr Novak <Petr.Novak@xxxxxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 17 Feb 2011 19:20:36 +0000
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
Other related posts:
