ALTER TABLE sales PARALLEL 8; ALTER TABLE customers PARALLEL 4;
In this example, queries accessing just the
sales table use a requested DOP of 8 and queries accessing the
customers table request a DOP of 4. A query accessing both the
sales and the
customers tables is processed with a DOP of 8 and potentially allocates 16 parallel servers (producer or consumer); whenever different DOPs are specified, Oracle Database uses the higher DOP.