RE: snapshot too old

[Pradip_Biswas]

2. Fix: Increase Rll Back segments 1. Why: Oracle RDBMS tries to provide "Read consistent " viiew of the data ( changed or clean ) at the "statement level" read consitency and "transaction level" read consistency This is one of the whys-  an Oracle DBA's makes his living in their employment as Oracle DBA.   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, March 28, 2003 12:19 PM To: Multiple recipients of list ORACLE-L Subject: snapshot too old why a select statement can give snapshot too old erorr . there is no update , yes but its a long running query . what is fix for this ?   -ak