First of all, you need to identify the longes running query.
Second, you need to set the undo_retention initialization parameter to that time (say your longest running query is 2 hours, set undo_retention=7200).
Third, allocate enough space un the undo tablespace.
Cheers,




Reply With Quote