Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How much undo is too much?
rjqjunk_at_vt.edu wrote:
> I've read in this forum that you can't just go around allocating
> 'oodles' of undo space because the management of said space fills up
> the buffer. So how do you tell when you've reached the 'oodles' stage
> and you should stop allocating?
>
> I'm trying to balance the overall performance of the db with the needs
> of a couple of jobs that are periodically run.
Look at the graph in OEM. It provides a clear interface for answering the questions you have asked.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Fri May 14 2004 - 23:35:20 CDT