Re: High "transaction rollbacks" value in v$sysstat

See his recent blog entries:

http://tkyte.blogspot.com/2005/08/something-different-part-i-of-iii.html

http://tkyte.blogspot.com/2005/08/part-ii-seeing-restart.html

http://tkyte.blogspot.com/2005/09/part-iii-why-is-restart-important-to.html

*Very* interesting reading.

---Phil

On 10/09/05, Lex de Haan <lex.de.haan_at_naturaljoin.nl> wrote:
> yep -- the famous (but less well known) Oracle feature "write consistency"
> search Tom Kytes's website for the abover term, and you'll find a few
> interesting threads.
> or better, try to attend one of his public seminars he is teaching; this happens
> to be one of his favorite topics ;-)
>
> kind regards,
>
> Lex.
>
> ------------------------------------------------------------------
> Steve Adams Seminar http://www.naturaljoin.nl/events/seminars.html
> ------------------------------------------------------------------
>
> -----Original Message-----
>
> ----------------------------------------------------------------------------
> From: Andrew Allen 26-Apr-05 15:29
> Subject: Re : User rollbacks higher then user commits
>
> Could be blocked updates causing the rollbacks. I do not know the source of the
> stat in the statspack report, but I will bet that this is it.
>
>
>

--
http://www.freelists.org/webpage/oracle-l