Re: rollback segment problem

Hi,
You should do the follows things:

1. Increase de rollback size;
2. Increase commits during transactions;
3. Reduce number of rows during the process;
4. Add rollback segments;
5. Avoid fetch across commits;

luizgoms_at_sucesumg.org.br

daud11_at_hotmail.com wrote:

> 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
> for all the rollback segments 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 - 20:36:27 CDT