1 Reply Latest reply: Jun 3, 2008 6:54 AM by Eduardo Legatti RSS

    TUNED_UNDORETENTION

    582889
      hi.
      Oracle 10g
      Is ıt true When we set the undo_retention=0,
      the new UNDO RETENTION will be set to TUNED_UNDORETENTION.
      TUNED_UNDORETENTION = MAXQUERYLEN + 300 Sec.
        • 1. Re: TUNED_UNDORETENTION
          Eduardo Legatti
          Hi,

          According to Note:240746.1, if UNDO_MANAGEMENT=AUTO (no matter the setting for UNDO_RETENTION) automatic undo tuning will be used. If UNDO_RETENTION is set > 0, the value specified acts as a minimum setting ... In addition, Mr. Laurent Schneider has been written an article at his [url http://laurentschneider.blogspot.com/2006/08/tunedundoretention.html]old blog about TUNED_UNDORETENTION

          Cheers

          Legatti