Re: Who/what is causing the rollbacks?

Given that it is a web application, there may be nothing you can do. However, although the number of calls to 'rollback;' may be relatively high (I've seen it match the number of commits before now) the AMOUNT of rollback change may be relatively insignificant.

Check v$sysstat for:

    "rollback changes - undo records applied" and see if this is just a couple or so changes per call.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.

Prince Kumar wrote in message
<629275ba.0109061553.73a181ff_at_posting.google.com>...


>Thank you all, for your responses.

>

>Jonathan: Its an web based application and our web server is Apache .

>

>HJR: I am wondering whether its possible to find the statements

>getting rolled back.

>

>Stephen: I can easily get the statistics (in fact I already got it)

>Since most of our connection is persistent and the "user rollbacks" is

>spread across the sessions almost uniformly, it is hard to get any

>useful info out of it (other than knowing they do lot of rollbacks).

>