dbatricksworld.com
ORA-01555 Snapshot Too Old
This error is all about read consistency, consider a scenario: undo_retention is set to 15min (900 seconds), you started long running query at 9am, and the query runs for next 1 hours, any DML tran…