1 2 Previous Next 22 Replies Latest reply: Aug 10, 2012 8:08 AM by Jonathan Lewis RSS

    stats gather error

    950724
      Database version is 11g r1 11.1.0.6
      I am trying to gather stats of schema I am facing following error

      SQL> exec dbms_stats.gather_SCHEMA_stats(ownname=> 'WMWHSE1',estimate_percent=> dbms_stats.auto_sample_size,method_opt=> 'FOR ALL COLUMNS SIZE AUTO',cascade=> TRUE);
      BEGIN dbms_stats.gather_SCHEMA_stats(ownname=> 'WMWHSE1',estimate_percent=> dbms_stats.auto_sample_size,method_opt=> 'FOR ALL COLUMNS SIZE AUTO',cascade=> TRUE); END;

      *
      ERROR at line 1:
      ORA-03113: end-of-file on communication channel
      Process ID: 24820
      Session ID: 1038 Serial number: 34509

      First time I successfully done gather stats of schema but second time I am tring to do but given the error
        1 2 Previous Next