Title: RE: UNDO RETENTION

Having had frustration with rollback segments from time to time over the years I am happy to let Oracle handle it with their recommended automatic undo management and a defined undo tablespace.  However, it isn't that simple is it?  I imagine that undo retention is critical and if you specify too long you might have problems with performance while too little and what you loose read-consistency - any ideas on the best way to configure this little bugger? 

Reply via email to