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.
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 old blog about TUNED_UNDORETENTION Cheers Legatti