I faced with that error on Oracle 11g.

The alert log reports next error details:

ORA-04030: out of process memory when trying to allocate XXX bytes (kkoutlCreatePh,apppred : kkotbalp)

For this error, more details can be found at Bug 13354720 – ORA-4030 DUE TO HIGH KKOUTLCREATEPH MEMORY ALLOCATION page on MOS.

We got this error because huge amounts of memory is required to analyze for bitmap processing for such a large number of inlist predicates.

So workaround is set below hidden parameter :
“_b_tree_bitmap_plans”=false

Reference:

ORA-04030 Error With High “kkoutlCreatePh” (Doc ID 1618444.1)