7 Replies Latest reply: Dec 27, 2012 1:46 PM by marksmithusa RSS

    Statistics Gather taking Too long time...

    user8983130
      Hi,

      I have started to execute gathering statistics for one of my schema :

      BEGIN
      DBMS_STATS.GATHER_SCHEMA_STATS (OWNNAME=>'DWH', CASCADE=>TRUE,ESTIMATE_PERCENT=>10);
      END;
      /

      My db size is only 20 GB. But the procedure is still running for 7 hours. Can any one suggest how i can find why the task taking so much time or how to monitor the running procedure???

      And ,what does the last two string means by

      CASCADE=>TRUE,

      and

      ESTIMATE_PERCENT=>10

      ???