Re: ORA-01555 Snapshot too old

From: Luis Nobre <lcnobre_at_americel.com.br>
Date: 7 Nov 2001 10:41:01 -0800
Message-ID: <72646b0e.0111071041.59ade151@posting.google.com>

ralf.pickart_at_gmx.net (Ralf Pickart) wrote in message news:<78ef525e.0111070755.5573ca68_at_posting.google.com>...
> Hi,
>
> I've a question about ORA-01555 and long running queries.
>
> We get this error on a select because of the delayed block cleanout
> after a large insert into a table. Obviously Oracle uses the delayed
> block cleanout only on long running transactions.
>
> Now we are looking for a workaround for this really nerving error and
> we're asking us what is a long running transaction? Especially we want
> to know how long a transaction may be before Oracle delays the block
> cleanout? Or is there another way to avoid this error?
>
> Who knows the answer?
>
> Regards
> Ralf

Hi, Ralf.

Try this site http://asktom.oracle.com/pls/ask/FLOWS.wwv_flow.accept

I'm sure you'll find your answer.

Best regards.
Luis Nobre, from Brazil. Received on Wed Nov 07 2001 - 12:41:01 CST