Re: ORA-01555 snapshot too old in Oracle 8.1.7

"Andrei Romazanov" <romazanov.andrei_at_gfos.de> wrote in message news:<b3ndmp$1nd4oc$1_at_ID-70985.news.dfncis.de>...
> Hello all,
>
> after the conversion 8.0.5 - > 8.1.7 I get error Ora-01555 snapshot too
> old: roll-bake segment...
> in the situation, where in former times everything ran perfectly.
>
> Is it
> 1. Coincidence? (the size of the snapshot has just now the critical limit
> exceeded)
> 2. error in the settings?
> 3. bug in 8.1.7?
>
> Thank you in advance
> Andrei

Andrei, The ORA-01555 is a fairly common error that can happen from time to time just due to circumstances so is the problem repeatable? That is when you tried to rerun did the job finish successfully or take another ORA-01555 error?

If the error repeats then try looking at the explain plan. It may have changed with the upgrade due to changes in the CBO routines. A little tuning could be all you need. Also I hope you did reanalyze all your objects after the upgrade. If already did this it is possible you caught some tables (work/report) at a bad time and re-analyzing the tables involved in this job may be worthwhile. I would check the explain plan before and after to see if reanalyzing has any effect.

HTH -- Mark D Powell -- Received on Fri Feb 28 2003 - 08:57:06 CST