Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Who/what is causing the rollbacks?
"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