4 Replies Latest reply: Jan 22, 2013 8:17 PM by Arun Natarajan-OC RSS

    ORA-20011: Approximate NDV failed: ORA-31000: Resource Error in Oracle 11g

    Arun Natarajan-OC
      Hi Friends,

      I am using Oracle 11.2.0.1 on linux (x64) and i am getting the following messages in Alert Log / Trace Log.

      Please let me know the fix.

      Alert Log:
      -----------------

      GATHER_STATS_JOB encountered errors. Check the trace file.
      Errors in file /u01/app/oracle/diag/rdbms/oraht01/oraht01/trace/oraht01_j001_30852.trc:
      ORA-20011: Approximate NDV failed: ORA-31000: Resource '' is not an XDB schema document
      ORA-06512: at "XDB.XDB$ACL_PKG_INT", line 18

      Trace File entries:
      ---------------------------------
      ----- Guard Frame Metadata Dump -----
      ----- Java Stack -----
      ORA-20011: Approximate NDV failed: ORA-31000: Resource '' is not an XDB schema document
      ORA-06512: at "XDB.XDB$ACL_PKG_INT", line 18

      *** 2013-01-21 22:00:36.397
      GATHER_STATS_JOB: GATHER_TABLE_STATS('"XDB"','"XDB$ACL"','""', ...)
      ORA-20011: Approximate NDV failed: ORA-31000: Resource '' is not an XDB schema document
      ORA-06512: at "XDB.XDB$ACL_PKG_INT", line 18


      Regards,
      DB