Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Ratio rollbacks/transactions is 90%

Ratio rollbacks/transactions is 90%

From: paquette stephane <stephane_paquette_at_yahoo.com>
Date: Fri, 5 May 2000 04:22:12 -0700 (PDT)
Message-Id: <10488.105037@fatcity.com>


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


Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger. Received on Fri May 05 2000 - 06:22:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US