4 Replies Latest reply: Mar 8, 2011 11:13 PM by afzal RSS

    what is the reason TUNED_UNDORETENTION is zero

    afzal
      what is the reason TUNED_UNDORETENTION is zero



      SQL> select to_char(begin_time, 'DD-MON-RR HH24:MI') begin_time,
      t 2 o_char(end_time, 'DD-MON-RR HH24:MI') end_time, tuned_undoretention
      3 from v$undostat order by end_time;


      BEGIN_TIME END_TIME TUNED_UNDORETENTION
      --------------- --------------- -------------------
      08-MAR-11 16:45 08-MAR-11 18:53 0