This discussion is archived
2 Replies Latest reply: Oct 20, 2012 8:08 PM by BobCarlin RSS

gather statistics in parallel on schema

user1779355 Newbie
Currently Being Moderated
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. Journeyer
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points