dbaplus Community

Feb 23, 2016 · Databases

Understanding ORA-01555: Causes and Effective Fixes for Oracle Snapshots

This guide explains why the ORA-01555 "snapshot too old" error occurs in Oracle databases, where related logs are stored, the underlying UNDO and LOB mechanisms that trigger it, and step‑by‑step solutions to diagnose and eliminate the problem.