Re: Snapshot too old?

From: Glenn Baron <gbaron_at_dial.pipex.com>
Date: 26 Oct 1999 15:51:16 GMT
Message-ID: <01bf1fc9$f8bebac0$e35195c1@default>

Yep
Also, it's typically a problem for long-running queries so maybe submit these out-of-hours (if you have any). Maybe the query needs tuning if it's taking so long as to cause 'snapshot too old...'

Glenn Baron

Yosi Greenfield <ygreenfield_at_compuserve.com> wrote in article <3815C895.BFB8DCD9_at_compuserve.com>...
> This could mean you rollback segs are too small. That's like the standad
> answer. More likely, it means you're committing while fetching data with
an
> open cursor. The commit releases the rollback still used by your query.
>
> To solve, either 1) commit only once, at the end, or 2) at each commit,
> close your cursor and reopen it to query the as-yet unqueried rows.
>
> HTH,
>
> Yosi
>
>
> ropru_at_my-deja.com wrote:
>
> > Can someone explain me please what could cause this message to appear:
> >
> > "Snapshot too old. Segment Data_Rd11 to small
> >
> > no rows selected"
> >
> > I am doing some changes to really complex query and I got this message.
> >
> > Thank you
> >
> > Roman
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
Received on Tue Oct 26 1999 - 10:51:16 CDT