Database Administration & Monitoring
When you change the UNDO_RETENTION parameter, the LOB segment’s retention value is not modified
18.03.2019 by Oracle Team
Below, I will try to explain, a particular case for the general error : ORA-01555 snapshot too old error.. Normally, when we have this error, we are trying to adapt the retention parameters or to tune our queries. SQL> show(…)