Re: Who/what is causing the rollbacks?

From: Stephan Bressler <agadir_at_web.de>
Date: Thu, 6 Sep 2001 08:35:49 +0200
Message-ID: <9n75gc$c4k$1@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 - 01:35:49 CDT