0 Replies Latest reply on Mar 29, 2015 11:42 AM by LZS77

    Experiences with DBMS_STATS.PURGE_STATS(DBMS_STATS.PURGE_ALL)

    LZS77

      Hi

       

      We have been advised by Oracle Support to run DBMS_STATS.PURGE_STATS(DBMS_STATS.PURGE_ALL) to purge the stats in the SYSAUX tablespace as per Note 454678.1 - we have tried it in a couple of test environments and we haven't seen any issues as yet.

       

      Our environment is EBS R12.1.3 on 11.2.0.2.

       

      Just wanted to know if anyone else has tried this in a Production environment and if they faced any issues?

       

      Thanks