Re: How much undo is too much?

Howard J. Rogers wrote:

> I didn't make the original comment, but it's hinting at the biggest
> mistake I've ever made with Oracle.
>
> Believing automatic undo to be the best thing since sliced bread, and
> also believing the marketing hype surrounding it, it seemed to me that
> it would do no harm to have an enormous undo tablespace, so you had
> near-infinite flexibility with regard to undo_retention.
>
> However, the algorithm Oracle uses for automatic undo goes something
> like this: "For each new transaction, create a new undo segment. Until
> some mysterious point is reached where you think there's enough undo
> segments, and you start making new transactions share existing segments".

I think you're supposed to put

COMMIT; in there somewhere. ;-)

-- 
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)