Re: Causes for high "Rollback per transaction %" in AWR report
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 20 Nov 2012 15:21:28 -0000
----- Original Message -----
From: "Thomas Kellerer" <thomas.kellerer@xxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
