Functions prevent queries going parallel , in-built functions do not.

select is_number(col1) from table;

Will NOTgo parallel is the is_number function is a user written function, whereas

select regexp_like(col1, '^-?[[:digit:],.]*$') then 'Numeric' else 'Non-Numeric' ed

from table

WILL GO Parallel