Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: UNDO_RETENTION and performance

Re: UNDO_RETENTION and performance

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 15 Nov 2005 08:40:20 -0800
Message-ID: <1132072907.521135@yasure>


PuntAndPuntOften wrote:
> Any guesses on whether increasing UNDO_RETENTION has a negative impact
> on performance?

Of course it does. It also has a positive impact on performance. Depends on your specific application and usage.

Time to stop punting so often and learn how to benchmark.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Tue Nov 15 2005 - 10:40:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US