Message-Id: <10488.105037@fatcity.com>
From: =?iso-8859-1?q?paquette=20stephane?= <stephane_paquette@yahoo.com>
Date: Fri, 5 May 2000 04:22:12 -0700 (PDT)
Subject: Ratio rollbacks/transactions is 90%

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@yahoo.com
spaquette@houra.fr
(33) 01 53 93 06 50

__________________________________________________
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.