High "transaction rollbacks " value in v$sysstat 2005-09-10 - By Lex de Haan
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.
|
|
