Getting WARNING: too many parse errors for a Query using PARALLEL hint

 Problem:

In a 19c RAC DB I can notice tons of warnings being written to the alertlog regarding one query using PARALLEL hint:

WARNING: too many parse errors, count=340228 SQL hash=0x54099e3e
PARSE ERROR: ospid=14403, error=12850 for statement:
2022-07-30T04:33:14.217222+00:00
.....
Additional information: hd=0x112d68830 phd=0x117e47188 flg=0x101476 cisid=123 sid=123 ciuid=123 uid=123 sqlid=7j3j8h9a0m7jy
 

Analysis:

When checking the plan for that statement, I found there are 115 child plans, which looks weird:

SQL> select child_number,address,hash_value,last_load_time from v$sql where sql_id='7j3j8h9a0m7jy';

 

I found that the symptoms are matching bug 2816169.1, because that query was also using a PARALLEL hint:
Warning: Too Many Parse Errors With ORA-12850/ORA-12872 (Doc ID 2816169.1)

Solution:

I didn't apply the mentioned solution in the Bug note which to set "_nlj_batching_enabled"=false, but I just removed the PARALLEL hint from that query to avoid hitting that bug at the first place, then I can no more see that Warning for that SQLID in the alertlog.

References:

Warning: Too Many Parse Errors With ORA-12850/ORA-12872 (Doc ID 2816169.1)