High "transaction rollbacks " value in v$sysstat 2005-09-08 - By Lou Fangxin
Check you application, is there so much rollback in you application, or
rollback to save point?
On 9/9/05, Allen, Brandon <Brandon.Allen@(protected)> 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.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
--
Welcome, http://www.anysql.net/en/
<div>Check you application, is there so much rollback in you application, or
rollback to save point?</div>
<div> </div>
<div><br><span class="gmail_quote">On 9/9/05, <b class="gmail_sendername">Allen
, Brandon</b> <<a href="mailto:Brandon.Allen@(protected)">Brandon.Allen
@(protected)</a>> wrote:</span></div>
<div>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0
.8ex; BORDER-LEFT: #ccc 1px solid">I just noticed in a <a href="http://9.2.0.6"
>9.2.0.6</a> 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":
<br><br>Statistic
Total per Second per
Trans<br>-- ---- ---- ---- ---- ---- ----- -- ---- ---- ----- -- ---- ------ --
-- ---- --<br>transaction rollbacks
3,640,974  
;
31.6 1.3<br>user
calls
135,007,494
1,172.0 47.4<br>user
commits
2,845,562
24.7
1.0<br>user rollbacks  
;
21
0.0 0.0<br><br>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?
<br><br>Thanks,<br>Brandon<br><br>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.
<br><br>--<br><a href="http://www.freelists.org/webpage/oracle-l">http://www
.freelists.org/webpage/oracle-l</a><br></blockquote></div><br><br clear="all">
<br>-- <br>Welcome, <a href="http://www.anysql.net/en/">http://www.anysql.net/en
/
</a>
|
|
