Re: Who/what is causing the rollbacks?

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).

Prince..

"Stephan Bressler" <agadir_at_web.de> wrote in message news:<9n75gc$c4k$1_at_news.mch.sbs.de>...
> Hi,
>
> look at v$sesstat to find the top-rollback-sessions (you may need to join to
> v$statname.statistic# to get the statistic names).
>
> Regards
> Stephan
>
>
> "Prince Kumar" <gspk_at_yahoo.com> schrieb im Newsbeitrag
> news:629275ba.0109051138.f731258_at_posting.google.com...
> > While reading the statspack report I noticed a very high percentage of
> > rollback.
> >
> > Is there any way to find who/what is causing all these rollbacks. If
> > "logminer" is the only solution, which table.column of v$logminer...
> > view tells me whether the operation was "rollback"?
> >
> >
> > thanks,
Received on Thu Sep 06 2001 - 18:53:48 CDT