Re: High "transaction rollbacks" value in v$sysstat
- From: Lou Fangxin <anysql@xxxxxxxxx>
- To: Brandon.Allen@xxxxxxxxxxx
- Date: Fri, 9 Sep 2005 07:15:16 +0800
Check you application, is there so much rollback in you application, or
rollback to save point?
On 9/9/05, Allen, Brandon <Brandon.Allen@xxxxxxxxxxx> wrote:
> I just noticed in a 9.2.0.6 <http://9.2.0.6> instance on Win2K3 that
> statspack is reporting a lot of rollback in the "transaction rollbacks"
> statistic, but a much more reasonable (smaller) value for "user rollbacks":
>
> Statistic Total per Second per Trans
> --------------------------------- ------------------ --------------
> ------------
> transaction rollbacks 3,640,974 31.6 1.3
> user calls 135,007,494 1,172.0 47.4
> user commits 2,845,562 24.7 1.0
> user rollbacks 21 0.0 0.0
>
> I searched Metalink for bugs but didn't find anything. Is it even possible
> for these values to be correct? My understanding is that 'transaction
> rollbacks' is a subset of 'user rollbacks', i.e. URs is incremented
> everytime a user issues 'rollback' even if there is nothing to actually be
> rolled back, but TRs is only incremented when actual rollback work is
> performed. Is my understanding incorrect/incomplete? If so, what could be
> the cause of all this rollback activity?
>
> Thanks,
> Brandon
>
> Privileged/Confidential Information may be contained in this message or
> attachments hereto. Please advise immediately if you or your employer do not
> consent to Internet email for messages of this kind. Opinions, conclusions
> and other information in this message that do not relate to the official
> business of this company shall be understood as neither given nor endorsed
> by it.
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
Welcome, http://www.anysql.net/en/
Other related posts:
