Hi,
I have my database the size of 12 GB with 7 GB of tempfiles. Recently I got "Ora-01555, snapshot too old: rollback segment number string with name " " too small ORA-22924" error.
Post that i have increased undo_retention parameter from 900 to 40000 and the size of undo tablespace to 10 GB.
Again I got the same error.
After that i have increased undo_retention parameter from 40000 to 75000 and the size of undo tablespace to 20 GB.
I have made the undo tablespace retention guarantee but still i am getting the above error.
Kindly suggest me how do i avoid the error. As I feel 20GB undo tablespace and undo retention of 75000 value is far enough to hold the rollback info on the database with the size of 12GB.
Kindly suggest me to resolve this issue.
Thanks in advance.