how many parallel executionin oacle query we can use code example

Example: set parallel in oracle

SELECT /*+ parallel(auto) */ ename, dname FROM emp e, dept d
WHERE e.deptno=d.deptno;