Re: Ora-1555

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 13 Mar 2003 23:19:32 +1000
Message-ID: <Xl_ba.2373$LT.7034@newsfeeds.bigpond.com>

"Stan" <stan0074_at_yahoo.com> wrote in message news:3E7042B3.2020909_at_yahoo.com...
> GC wrote:

<Snip>

> Why would an ora 1555 be thrown on a query that is not referencing any
> > blocks in any rollback segments? I have a tar open and am running
> > systemstate and errorstack traces when this issue replicates itself,
> > but has anyone here had a similiar problem or can fill what I may be
> > missing?
> >
> > Database is a 9.0.1.4 64bit system running on hp-ux 11. Somewhat large
> > batch system with ample rollback space (20 rollback segs, 13 GB usable
> > rollback space - perhaps overkill, but it was like this when I got
> > here and I don't want to give up disk space if I don't have to :)
> >
> > Thanks,
> > Greg
>
> Hi,
>
> quick question, did these tables A, B and C undergo heavy changes or
> data loads prior to running this query. if yes then i would lean towards
> delayed block cleanout causing ora 1555 error.
>

Hi Stan,

I second the motion.

Richard Received on Thu Mar 13 2003 - 07:19:32 CST