3 ms·
Today I just woke up to find yet another "ORA-01555: snapshot too old" on something I left running overnight. Honestly, performance isn't as important as the c
by marcosdumay 7y ago
Today I just woke up to find yet another "ORA-01555: snapshot too old" on something I left running overnight.
Honestly, performance isn't as important as the capacity of getting an atomic snapshot of your data with any reliability.
- ComodoHacker 7y agoAvoiding ORA-01555 is a matter of properly sizing your undo.
- marcosdumay 7y agoAnd a matter of not getting any task that is slower than what you expected.