Re: RE : Ratio rollbacks/transactions is 90%

Stephane,

If you check USED_UBLK and USED_UREC from V$TRANSACTION and those values are decreasing, this usually indicates a tx that's rolling back.

HTH,

• Anita

>From: paquette stephane <stephane_paquette_at_yahoo.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: RE : Ratio rollbacks/transactions is 90%
>Date: Fri, 05 May 2000 06:01:26 -0800
>
>V$transaction.status seems to contain 'active' all the
>time.
>What I'll try now, is to verify with logminer if the
>commit /rollback keywords are stored in the redo, if
>so I'll look for a pattern of a rolled back
>transaction.
>
>
>
>--- Stephane Faroult <sfaroult_at_oriolecorp.com> a
>écrit:
> > I am not 100% sure about this, but the STATUS field
> > in V$TRANSACTION
> > might indicate that a rollback is going on ? The
> > SES_ADDR field should
> > enable you to join on V$SESSION(ADDR) and hence
> > V$SQLAREA or V$SQLTEXT.
> > But it musn't be easy to catch rollbacks as they
> > occur.
> > --
> > HTH,
> >
> > Stephane Faroult
> > email: sfaroult_at_oriolecorp.com
> > Oriole Corporation
> > Voice: +44 (0) 7050-696-269
> > Fax: +44 (0) 7050-696-449
> > Performance Tools & Free Scripts
> >
>------------------------------------------------------------------
> > http://www.oriolecorp.com, designed by Oracle DBAs
> > for Oracle DBAs
> >
>------------------------------------------------------------------
> > >
> > > Hi all
> > >
> > > The ratio of rollbacks/number of transactions is
> > 90%
> > > on our prod db, which is very high. The ratio
> > comes
> > > from user rollback/(user rollback + user commits)
> > from
> > > v$sysstat.
> > >
> > > I've done a trace on a session that appears as the
> > top
> > > user rollbacks producer according to top session
> > > (Enterprise manager) but found nothing.
> > >
> > > How can I discovered where those rollbacks are
> > coming
> > > from ? Can i see somewhere what kind of
> > transactions
> > > are rolled back ?
> > > It's a web application using Vignette's Story
> > Server
> > > which commits automatically each calls to the
> > rdbms.
> > >
> > > TIA
> > >
> > > =====
> > > Stephane Paquette
> > > DBA Oracle
> > > stephane_paquette_at_yahoo.com
> > > spaquette_at_houra.fr
> > > (33) 01 53 93 06 50
> > >
>
>=====
>Stephane Paquette
>DBA Oracle
>stephane_paquette_at_yahoo.com
>spaquette_at_houra.fr
>(33) 01 53 93 06 50
>
>__________________________________________________
>Do You Yahoo!?
>Send instant messages & get email alerts with Yahoo! Messenger.
>http://im.yahoo.com/
>--
>Author: =?iso-8859-1?q?paquette=20stephane?=
> INET: stephane_paquette_at_yahoo.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).