Re: Causes for high "Rollback per transaction %" in AWR report

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 20 Nov 2012 15:21:28 -0000
Message-ID: <1B65B6EDE1A7432EA7EE8818ABFD36BF_at_Primary>


  • Original Message ----- From: "Thomas Kellerer" <thomas.kellerer_at_mgm-tp.com> To: <oracle-l_at_freelists.org> Sent: Tuesday, November 20, 2012 2:46 PM Subject: Re: Causes for high "Rollback per transaction %" in AWR report
 |                                          Total   per Second   per Trans

| rollback changes - undo records applied 6 0.00 0.00
| transaction rollbacks 3 0.00 0.00
| user rollbacks 23,511 6.52 0.98
|
| So, seeing the low number of "rollback changes", I assume the bottomline
is that I don't need to worry and concentrate on the other bottlenecks that we have already identified.
|

Yes,
Almost certainly

Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com/all-postings

Author: Oracle Core (Apress 2011)
http://www.apress.com/9781430239543

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 20 2012 - 16:21:28 CET

Original text of this message