Re: STATSPACK - Rollback per transaction %

On 12/28/05, Allen, Brandon 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