<P>Hi all,</P>
<P>I am getting ORA-01555 errors on my rollback segments. I know the usual practice is to resize the rollback segments which in most cases is to increase the size of your rollback segments. Am not using UNDO tablespaces and there is no plan to start using one, don't ask why.<BR><BR>While I can increase the size of the rollback segment, I want to know if anyone have any SQL or scripts that I can use to make a more intelligent or smart assessment of how large should I resize my rollback segment to?</P>
<P>Any advise will be greatly appreciated, thanks ...</P>
<P> </P>

Oracle LazyDBA home page