Re: AW: V$Transaction entry
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: Petr Novak <Petr.Novak@xxxxxxxxxxxx>
- Date: Fri, 18 Feb 2011 02:29:56 -0500
Hmmm, so, if you select used_ublk from v$transaction several times in a row,
does Rhe value increase, decrease, or stay the same?
Sent from my iPhone
On Feb 18, 2011, at 2:24 AM, "Petr Novak" <Petr.Novak@xxxxxxxxxxxx> wrote:
> Hallo Mark,
>
> there is no such session. From V$LOCKED_OBJECT I get SID 615 which does not
> exist.
>
> Best Regards,
> Petr Novak
>
> ________________________________________
> Von: Bobak, Mark [Mark.Bobak@xxxxxxxxxxxx]
> Gesendet: Donnerstag, 17. Februar 2011 22:02
> Bis: Petr Novak; Anjul
> Cc: oracle-l@xxxxxxxxxxxxx
> Betreff: RE: V$Transaction entry
>
> Hi Petr,
>
> So, if you take that row from v$transaction, can you identify the session
> with the following SQL?
>
> select sid,serial# from v$session where taddr in(select addr from
> v$transaction where <conditions to identify the row in v$transaction that
> you're interested in>);
>
> Then kill the session returned from this query.
>
> -Mark
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
> Behalf Of Petr Novak
> Sent: Thursday, February 17, 2011 3:44 PM
> To: Anjul
> Cc: oracle-l@xxxxxxxxxxxxx
> Subject: AW: V$Transaction entry
>
> Hallo Anjul,
>
> there is no row in dba_2pc_pending, only in V$transaction
>
> Mit freundlichen Grüssen
> Petr Novak
>
> ________________________________________
> Von: Anjul [anjulsahu@xxxxxxxxx]
> Gesendet: Donnerstag, 17. Februar 2011 20:55
> Bis: Petr Novak
> Cc: oracle-l@xxxxxxxxxxxxx
> Betreff: Re: V$Transaction entry
>
> 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<mailto: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
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
>
>
Other related posts:
