Re: rollback segment problem

From: Kevin A Lewis <KevinALewis_at_Hotmail.com>
Date: Mon, 17 May 1999 11:02:22 +0100
Message-ID: <mKR%2.4861$_A1.113@news-reader.bt.net>

You need to gain an understanding of the way Rollback Segments work and then either increase the size or number of rollback segments appropriately for your environment.

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

                        <KevinALewis_at_HotMail.com>

The views expressed herein by the author of this document are not necessarily those of BOCM PAULS Ltd. <daud11_at_hotmail.com> wrote in message news:7hog8v$3n$1_at_nnrp1.deja.com...
> Hi All
>
> I have a query which always fail with the following msg: Oracle Error
1555:
> ORA 01555: Snapshot too old: Rollback segment .... too small.
>
> What should I do? I have tried to increase the optimal size to 15M from
10M
> but still does not solve the problem.
>
> Any advice?
>
> Daud
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon May 17 1999 - 05:02:22 CDT