What is the order of importance for parallel query settings in a multitenant environment?
Oracle 12.1.0.2 Enterprise Multitenant Data Warehouse- PDB1 is main data storage DB, PDB2 is used to stored all BI Platform information
How does settings in the CDB effect the PDBs below it? Do tables and indexes with degree set to an integer trump the initialization parameter settings? I've read that parallel query hints trump everything else, but I do not know what happens when parallel_degree_policy=AUTO and a table's degree is set to DEFAULT and an index degree is 4. Or vice versa, the table's degree is 4 or 12 and the index is DEFAULT. The guides specify that if 2 tables are queried, the table with the highest degree sets the stage for the DoP.