Performance - EBS (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Performance Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center