Gathering database stats 19c degree
Hi team,
We have upgraded RDS database from 12.1 to 19c. After that we have experienced mostly problems with slow jobs execution and lack of undo segments. I would like to re gather full database statistics by executing :
exec dbms_stats.gather_database_stats(estimate_percent => 20, degree => ? );
I know that this can be time expensive operation so I would like to place in degree. As I know degree equal to the number of CPUs - 1.
I have checked number of CPU's with show parameter CPU_COUNT and it returns 48.
I just wanted verification from someone is it safe to place degree to 47 then? Also to mention that i was thinking to place degree to AUTO but current value of PARALLEL_DEGREE_POLICY parameter is set to MANUAL.