Re: snapshot too old

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.

-- 
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)