Take a look at Tom Kyte's book to see whether delayed block cleanout is the
issue. As the others say, it seems likely. Tom also talks about what you
can do about this ... analyze etc.
"Richard Foote" <richard.foote_at_bigpond.com> wrote in message
news:Xl_ba.2373$LT.7034_at_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 Fri Mar 14 2003 - 16:47:25 CST
