How to correct/avoid “ORA-01555 Snapshot Too Old” ( corriger l’erreur ORA-01555 Snapshot Too Old d’Oracle )

How to correct/avoid “ORA-01555 Snapshot Too Old” ( corriger l’erreur ORA-01555 Snapshot Too Old d’Oracle )

ORA-01555 Snapshot Too Old

Action: If in Automatic Undo Management mode, increase the setting of UNDO_RETENTION. Otherwise, use larger rollback segments.

Augmenter le UNDO_RETENTION , ceci est le temps que Oracle garde en cache les données en secondes

exemple : UNDO_RETENTION=1800

Leave a Reply