Re: Alert to trap/anticipate ORA-01555 before its occurence

Joel Garry wrote:
> No one has mentioned the impact of optimal, so I'll just say turn it
> off if you are using it, let the rollbacks grow as much as they want,
> watch them to decide on a good size to shrink them to manually.
> Assuming you are not using undo, of course.

And on the same lines, don't go around dropping undo tablespaces without good cause!

Regards
HJR Received on Thu Dec 16 2004 - 05:12:06 CST