Ever run into the dreaded ORA-01555 error? It usually happens eight hours into your ten hour ETL run. With automatic undo management in Oracle 9i, this happens less often, but can still be a major headache. So you look at your ETL to try to find ways to improve and discover code like this: