Dear DBA Friends,
I'm running gather stats on a schema size - 1.1TB using gather_schema_stats. I have about 300 tables, (4 to 5 of them are partitioned). I would like to know what degree to use? As I understand, degree is relative to number of CPUs on the server and default is NULL. Below is the syntax I'm using for gather stats: (Pretty much all default arguments).
Do you suggest using degree? If so, auto degree value is fine? or CPU based?
Appreciate your thoughts!!!
EXEC DBMS_STATS.GATHER_SCHEMA_STATS(ownname => 'OWNER', cascade=> TRUE);