(https://docs.oracle.com/cd/E11882_01/server.112/e41573/hintsref.htm#CHDJIGDG)


SELECT /*+ PARALLEL(employees 3) */ e.last_name, d.department_name

FROM   employees e, departments d

WHERE  e.department_id=d.department_id;