Re: V$Transaction entry
- From: Anjul <anjulsahu@xxxxxxxxx>
- To: Petr.Novak@xxxxxxxxxxxx
- Date: Fri, 18 Feb 2011 01:25:17 +0530
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>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
Other related posts:
