To specify the degree of parallelism for a single query, include parallel after the table name. This example executes in serial:
select * from huge_table (parallel 1)
This example specifies the index to use in the query, and sets the degree of parallelism to 2:
select * from huge_table (index ncix parallel 2)
See “Suggesting a degree of parallelism for a query” for more information.