Re: V$Transaction entry

From: Anjul <anjulsahu_at_gmail.com>
Date: Fri, 18 Feb 2011 01:25:17 +0530
Message-ID: <AANLkTikye+iVfnEjM594Hq6inHUxvZDxDKrJaN8ZsSfS_at_mail.gmail.com>

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_at_/oracle_9i/doc/server.901/a90117/ds_txnma.htm

HTH
Anjul

On Fri, Feb 18, 2011 at 12:50 AM, Petr Novak <Petr.Novak_at_trivadis.com>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
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 

Anjul Sahu
Ph. +917869079958 | Gtalk: anjulsahu
Blog: http://anjulsahu.blogspot.com/
Facebook: http://www.facebook.com/anjuls

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Feb 17 2011 - 13:55:17 CST