In the Oracle databases version 22.214.171.124, 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='*';