Re: Rapid Rollback growth with Oracle 8

Thanks for your input.

My working theory at present is that the sizing of the segments were borderline anyway and a more generous use of space with the changes to Oracle 8 means that more space is used for the same levels of rollback.

If anyone knows different please post the info here.

Regards

--
Kevin A Lewis (BOCM PAULS LTD - Animal Feed Manufacturer - Ipswich England)

                        <Kevin.Lewis_at_BOCMPAULS.co.uk>

The views expressed herein by the author of this document are not necessarily those of BOCM PAULS Ltd. John Higgins <JH33378_at_deere.com> wrote in message news:3727BAD9.ED094CDD_at_deere.com...
> We have recently upgraded all of out SAP databases from Oracle 7.2.3 to
Oracle
> 8.0.4 on HP UX 10.20.
>
> We have not seen this on any of our systems.
>
> We have SAP R/3 versions 3.0E, 3.1H, 4.0B and one sandbox 4.5B.
>
> Kevin A Lewis wrote:
>
> > We have a production SAP-R3 system that we are preparing to upgrade.
Part of
> > the preparation for that upgrade was to take to database from Oracle
7.2.3
> > up to Oracle 8.0.4.3.0.
> >
> > Our experience since then is to see rapid extent growth in Rollback
Segments
> > of which we have 10. Prior to this the size of these segments was
static.
> > i.e. no growth needed.
> >
> > Nothing about the application has changed or our use of it. Is there
> > something in the changes between Oracle versions that should produce the
> > effect?
> >
> > We are seeking to understand the change in order to manage the
situation.
> >
> > Regards
> >
> > Kevin
> >
> > --
> > Kevin A Lewis (BOCM PAULS LTD - Animal Feed Manufacturer - Ipswich
England)
> > <Kevin.Lewis_at_BOCMPAULS.co.uk>
> >
> > The views expressed herein by the author of this document
> > are not necessarily those of BOCM PAULS Ltd.
>
Received on Thu Apr 29 1999 - 03:25:22 CDT