2 Replies Latest reply on Oct 21, 2012 3:08 AM by BobCarlin-Oracle

    gather statistics in parallel on schema

      I a trying to gather stats in parallel on a schema in which tables are OLTP compressed

      The command I use

      DBMS_APPLICATION_INFO.set_module ('Gather Stats', user);
      DBMS_STATS.GATHER_SCHEMA_STATS(ownname=>'schemaname', DEGREE=>64, estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE, method_opt => 'FOR ALL COLUMNS SIZE AUTO', CASCADE => TRUE, GRANULARITY => 'AUTO');

      I see blocker with wait event=PX DEQ: Execution Msg
      Waiter with wait event= PX Deq: Execute Reply

      When I run ASH report all I see is : IPC send completion sync

      anybody see this issue on on x2-2 half rack

        • 1. Re: gather statistics in parallel on schema
          Dave M.-Oracle
          Hi User1779355 -

          The My Oracle Support Community which covers all support related questions about EXADATA is available under: https://communities.oracle.com/portal/server.pt/community/exadata_general/360

          Have you ever visited the Community to exchange, learn, share and get answers to your support related questions?

          Your query is being progressed on the My Oracle Support Community for Exadata:

          If you have not used the My Oracle Support Communities before, please watch this brief (2 minute) video to help you quickly understand the benefits available to you.

          At your service,

          Dave M.
          • 2. Re: gather statistics in parallel on schema

            1. Are you having a performance problem, or are you just curious about these wait events? These are "normal" wait events when running parallel query
            2. Are you using CONCURRENT stats?