Give me the steps that How can I get the ORA-1555 snapshot too old error in Oracle9i.
Have a search at http://asktom.oracle.com/
"The Oracle Sponge"
Senior Manager, Business Intelligence Development
XM Satellite Radio
Open a cursor selecting everything from a table.
fetch the first row.
go away on holiday for a week while leaving lots of users and batch jobs to update the table.
come back and try to fetch the rest of the rows.