oracle Bug 30614411

Bug 30614411 is a known issue with Oracle Database that affects the performance of the database when executing queries with subqueries that contain certain types of joins. The bug has been identified in Oracle Database versions 12.1.0.2 and 18.4.0.0.

The workaround for this bug is to use the NO_MERGE hint in the subquery that contains the problematic join. Alternatively, you can also upgrade to a version of Oracle Database that includes a patch for this bug.

If you are experiencing performance issues with queries that involve subqueries and joins, it is recommended that you consult with Oracle support or a qualified Oracle database administrator to determine if Bug 30614411 is the root cause of the issue.