2 Replies Latest reply: Jan 1, 2013 12:17 AM by KrishnaAgnihotri RSS

    WRI$_OPTSTAT_HISTHEAD_HISTORY table bigger size

    KrishnaAgnihotri
      Hi

      I have sys.WRI$_OPTSTAT_HISTHEAD_HISTORY 7 Gb size. Information in this table is very old.

      GET_STATS_HISTORY_AVAILABILITY
      ---------------------------------------------------------------------------
      19-AUG-10 11.53.42.006430000 AM +05:30

      I want to purge this information up to sysdate -10. this take very long time (running for 5-6 hrs) and select count(*) from WRI$_OPTSTAT_HISTHEAD_HISTORY; -- 122389076 did not come down even to single record. then i start purge to exec DBMS_STATS.PURGE_STATS(SYSDATE-860); (purginf 1 day history) this is also seems not working.

      Kindly advice some action plan which can fastly purge the records.

      Thanks
      Krishna