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 22.214.171.124 on x2-2 half rack
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,
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?