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.
Latest posts by Nagulu Polagani (see all)
- Oracle E-Business Suite 12.2.6 VM Template Deployment - May 6, 2017
- Weblogic Zero Downtime Patching - May 1, 2017
- OAM Integration With Oracle Apps R12.2.x - March 10, 2017