ORA-01555 Snapshot too old error


ORA-01555 Snapshot too old error

The ORA-01555 is caused by Oracle read consistency mechanism.  If you have a long running SQL that starts at 11:00 AM, Oracle ensures that all rows are as they appeared at 11:00 AM, even if the query runs until noon.

 

 

 


Nagulu Polagani

"We are all apprentices in a craft where no one ever becomes a master."