Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Rollback generation rate

Re: Rollback generation rate

From: Brent <bpathakis_at_yahoo.com>
Date: 29 Oct 2002 07:14:08 -0800
Message-ID: <1736c3ae.0210290714.173974bd@posting.google.com>


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:

Received on Tue Oct 29 2002 - 09:14:08 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US