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 22:54:39 +0100
Message-ID: <403e6a81$0$22392$626a14ce@news.free.fr>

"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

Original text of this message

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