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
icrit:
> 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.
Received on Fri May 05 2000 - 07:50:13 CDT