STATSPACK - Rollback per transaction %

From: BN <bnsarma_at_gmail.com>
Date: 2005-12-22 16:09:40
Message-id: 61292a9d0512220709x6c109f7by7e4084f1c578984@mail.gmail.com

Greetings,

Sent to wrong address...

• Forwarded message ---------- From: BN Date: Dec 20, 2005 11:31 AM Subject: STATSPACK - Rollback per transaction % To: oracle-l-admins_at_freelists.org

Greetings
Oracle 9i Rel2 HP-UX

We collect Hourly STATSPACK snaps for the Prod. DB.

I pulled out couple of STATSPACK reports from on of our Production Database, and see that
"Rollback per transaction %" is upper 90%'s,

I wanted to approach the DEV/App team to find out why are they rollingback more than 90% of their work,

Before that I wanted to pull out the info from all the STASPACK Snaps I have,
I looked at the spreport.sql to see how they are arriving at this number, Not sure how I can make use of the following SQL to pull Rollback information for all the snaps I have.

Select .....

....

      ,' Rollback per transaction %:' dscr, round(100*:urol/:tran,2) pctval
      ,'      Rows per Sort:'     , decode((:srtm+:srtd)
                                                   ,0,to_number(null)
                                            ,round(:srtr/(:srtm+:srtd),2))

bpctval
 from sys.dual;

I apprecaite your suggestions/help to pull this info, or if somebody has already have a sql that they can share.

Regards & Thanks

--
Regards & Thanks
BN

Received on Thu Dec 22 2005 - 16:09:40 CST