Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Who/what is causing the rollbacks?

Re: Who/what is causing the rollbacks?

From: Howard J. Rogers <howardjr_at_www.com>
Date: Thu, 6 Sep 2001 13:26:30 +1000
Message-ID: <3b96ebe7@news.iprimus.com.au>

"Prince Kumar" <gspk_at_yahoo.com> wrote in message 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"?

You could try looking in the "operation" column (of v$logmnr_contents), for starters. But, in fact, Log Miner won't help. As far as redo is concerned, a rollback is just as committed as a commit: it just happens to leave data in exactly the same state after as before the transaction.

Regards
HJR
>
>
> thanks,
Received on Wed Sep 05 2001 - 22:26:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US