ORA-00600: internal error code, arguments: [qesdpSigError], [adaptive join resolution failed], [309], [], [], [], [], [], [], [], [], []

Issue :

Noticing below ORA-00600 errors in the database alert log.

ORA-00600: internal error code, arguments: [qesdpSigError], [adaptive join resolution failed], [309], [], [], [], [], [], [], [], [], []

Cause:

This seems to be a known bug adaptive plans feature being enabled and the error is hit when running the query involving bitmap indexes with star transformation enabled.

Fix:

It seems to be fixed in 12.2 version through bug 21156276. 

Otherwise, we can implement below workaround:

alter system set "_optimizer_adaptive_plans" = FALSE ;