RE: STATSPACK - Rollback per transaction %

Here is the relevant code from statspack.stat_changes, for some reason Outlook decided to \ convert it into an attachment the first time I sent it:

begin

. . .

      urol := SYSDIF('user rollbacks');
      ucom := SYSDIF('user commits');
      tran := ucom + urol;

-----Original Message-----

From: Ken Payton [mailto:ken.payton_at_choicepointprg.net] Sent: Wednesday, December 28, 2005 3:17 PM To: Jared Still
Cc: Allen, Brandon; bnsarma_at_gmail.com; Oracle-L Subject: Re: STATSPACK - Rollback per transaction %

Sounds correct. The problem seems to be with how statspack is reporting Rollback per transaction %. Apparently, from Allen's discovery, it seems statspack is using 'user rollbacks' as opposed to 'transaction rollbacks' in it's calculation.

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 Received on Wed Dec 28 2005 - 23:40:16 CST