Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Rollback generation rate
Vince Laurent <vlaurent_at_NOSPAM.networkusa.net> wrote in message news:<e78rru4vrd7sud7uv6etji7nos8mm5pkru_at_4ax.com>...
> I have been seeing messages from our monitoring software such as :
>
> DBSPI-0054.1: Rollbacks generation rate (384.20/minute) too high for
> QAS (>=50.00/minute).
> DBSPI-0054.1: Rollbacks generation rate (640.73/minute) too high for
> SND (>=50.00/minute).
>
> What does 'Rollback generation rate' mean?
>
> BTW, we use HP Openview and the Oracle plug-in to monitor the
> databases.
'Rollback generation rate' refers to how quickly you are generating rollback data (data needed to 'undo' a change, and for read consistency). It sounds like this particular message might be hinting at contention for rollback segments.
Some things you might check: