Search notes:

Oracle hint: PARALLEL

The parallel hint instructs the query engine to execute a query in parallel (if possible).

This hint overrides the parallel degree of a table and parallel parameters from the init.ora (or spfile).

Request parallel execution:

select /*+ parallel */ …

Specify a degree of parallelism (DOP):

select /*+ parallel(4) */ …

Specify a DOP for a specific table:

select /*+ parallel(sales, 4) */ …

See also