“PX Deq: Table Q Normal” wait event in parallel queries in Oracle database 12.2.0.1 version

In the Oracle databases version 12.2.0.1, when queries such as “insert into select…” are run in parallel as DOP 32, “PX Deq: Table Q Normal” wait event is seen in all parallel processes and the query is not completed. No problem occurs when operated with different DOP.

Queries with problems will be as follows.

SQL> INSERT /*+ APPEND */ INTO TABLO SELECT ....

The cause of the issue is bug number 29252790, and two different operations can be done to fix the issue .

  • The patch number 29252790 can be applied for the bug that causes it.
  • The value of the “_bloom_filter_enabled” parameter can be FALSE in the related session or across the database.You can change the parameter as follows.
alter system set "_bloom_filter_enabled" = FALSE scope=both sid='*';

 

Please follow and like us:

Leave a Reply

Your email address will not be published. Required fields are marked *