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
Received on Fri May 05 2000 - 07:23:17 CDT
