Re: ORA-01555 snapshot too old in Oracle 8.1.7

From: Alex Filonov <afilonov_at_yahoo.com>
Date: 28 Feb 2003 08:29:17 -0800
Message-ID: <336da121.0302280829.1504c430@posting.google.com>

"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

Have you noticed the difference in performance? What are your optimizer settings? If you had optimizer_mode=RULE before and now have it CHOOSE, you might need to tune some of you SQL statements.

If there is no performance problems, just try to increase rollback segments sizes. Diskspace is so cheap now. Received on Fri Feb 28 2003 - 10:29:17 CST