2 Replies Latest reply: Oct 20, 2012 10:08 PM by BobCarlin RSS

    gather statistics in parallel on schema

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

      The command I use

      BEGIN
      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');
      END;
      /

      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 11.2.0.3 on x2-2 half rack

      thanks
        • 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:
          https://communities.oracle.com/portal/server.pt?open=514&objID=224&mode=2&threadid=429910&aggregatorResults=T429910T426835T426876T422126T424767T422172T415389T420356T416710T413441&sourceCommunityId=360&sourcePortletId=268&doPagination=true&pagedAggregatorPageNo=1&returnUrl=https%3A%2F%2Fcommunities.oracle.com%2Fportal%2Fserver.pt%3Fopen%3Dspace%26name%3DCommunityPage%26id%3D25%26cached%3Dtrue%26in_hi_userid%3D173523%26control%3DSetCommunity%26PageID%3D0%26CommunityID%3D360%26&Portlet=All%20Community%20Discussions&PrevPage=Communities-CommunityHome

          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.
          http://bcove.me/rvjqwdn5

          At your service,

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

            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?

            Regards
            Bob