Erratic behavior of Oracle while selecting Degree of parallelism (DOP) for certain critical sqls
Hi,
Few critical sql's with same plan (profiles created and used too) are running at times in serial rather than in parallel hence take much longer hence causing huge application issues.
Checked the load on the DB at that point in time, there's nothing much running.
Is there a way we can ensure that particular sql's run with certain minimum DOP?
--DB Details
**************************************
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
2 node RAC - 8 CPUs
**************************************
--Related parallel paramters
NAME TYPE VALUE
------------------------------- ------- ------
awr_pdb_max_parallel_slaves integer 10
containers_parallel_degree integer 65535
fast_start_parallel_rollback string LOW