Re: snapshot too old

"Daniel Morgan" <damorgan_at_x.washington.edu> a écrit dans le message de news:1077819949.15202_at_yasure...
> Michel Cadot wrote:
>
> > 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
>
> Which was my point. Every byte of advice was off-the-mark for solving
> an ORA-01555.

And i agree completely.
Michel Cadot

>
> --
> 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)
>
Received on Thu Feb 26 2004 - 15:54:39 CST