Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: snapshot too old

Re: snapshot too old

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 26 Feb 2004 18:35:57 +0100
Message-ID: <403e2de1$0$22399$626a14ce@news.free.fr>

"Daniel Morgan" <damorgan_at_x.washington.edu> a écrit dans le message de news:1077813117.575546_at_yasure...
> x wrote:
> > The other workaround (if you really need to commit after 2500 rows) is to
> > declare cursor like this
> >
> > cursor c1 is select ssn from test_table order by 1;
> >
> > This will keep the cursor in temp segment, not in rollback segment.
> >
> > But, generally, don't 'fetch across commit', or in normal language don't
> > commit inside loop.
> >
> > And don't use larger rollback segments, since it won't solve your problem.
>
> Could you please find a single document supporting any of your
> statements from:
>
> otn.oracle.com
> tahiti.oracle.com
> docs.oracle.com
> asktom.oracle.com
>
> or any other reputable source?
>
> There is not a single sentence above that appears to be valid.
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>

For use a sort or don't use a fetch across commit:

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=18954.1
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_id=40689.1&p_database_id=NOT
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_id=1005107.6&p_database_id=NOT
and particulary
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=45895.1 (cause #4, solution 4a and 4c)

But maybe Metalink is not a reputable source? ;-)

These notes also say commit less often and use a larger rollback segment.

Regards
Michel Cadot Received on Thu Feb 26 2004 - 11:35:57 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US