Re: STATSPACK - Rollback per transaction %
- From: Jared Still <jkstill@xxxxxxxxx>
- To: Brandon.Allen@xxxxxxxxxxx
- Date: Wed, 28 Dec 2005 12:04:25 -0800
On 12/28/05, Allen, Brandon <Brandon.Allen@xxxxxxxxxxx> wrote:
>
> IIRC, when you issue a rollback and there isn't actually anything to be
> rolled back, then the 'transaction rollbacks' value in v$sysstat will not be
> incremented - only the 'user rollbacks' will be incremented. Someone please
> correct me if I'm wrong.
>
>
A quick test seems to confirm this behavior on 9.2.0.6.
'user rollbacks' is always updated.
'transaction rollbacks' is updated when there is actually something to
rollback.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Other related posts:
