Hi everybody,

Facing an age old problem
I am running a delete statement in a cursor (to commit in between)
I am commiting every 1000 records. The pl/sql block would delete about 8 million records.My undo management is automatic
Some stats:
table size : 1.2 GB
undo tablespace size 1 GB
Records to be deleted : about 8 million
commit : every 1000 records
undo retention: 900

Still it gives the error
ORA-01555: snapshot too old: rollback segment number 11 with name "_SYSSMU11$"
I have a hunch that my undo retention has to be increased.
If i am correct then about how much should i increase
Any help will be appreciated