High "transaction rollbacks " value in v$sysstat 2005-09-10 - By Phil Jones
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@(protected)> 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
|
|
