Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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