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

Home -> Community -> Usenet -> c.d.o.server -> Re: rollback segment problem

Re: rollback segment problem

From: Luiz Alberto Ferreira Gomes <luizgoms_at_sucesumg.org.br>
Date: Mon, 17 May 1999 22:36:27 -0300
Message-ID: <3740C41A.6A04D9FC@sucesumg.org.br>


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

Original text of this message

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