Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: snapshot too old
"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=NOTand particulary
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