A specific DOP can be requested from Oracle Database for both tables and indexes. For example, you can set a fixed DOP at a table level with the following:
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.