Please help me with these errors. I have a batch job that runs at night and failed with these errors.
ORA-00604: error occurred at recursive SQL level 1
ORA-02067: transaction or savepoint rollback required
ORA-01555: snapshot too old: rollback segment number 1 with name "RB_BIG" too small
I checked the batch job log for errors, these errors were reported by the job
ORA-00603:Oracle server session terminated by fatal error.
ORA-01041 :internal error. hostdef extension doesn't exist.
I need help to fix these errors.
RB_BIG is 2400K with optimal at 24000K, minextents 10 and maxextents 249. I do not know how large this job gets.
This topic has been discussed several thousand times in these forums. Please check http://www.dbasupport.com/forums/search.php
Click Here to Expand Forum to Full Width