Hi Experts
I had question on Auto Stats job in 12c which is running for 4hr now from 10pm
to 2am. I had multiple heavy used environment where lost of objects shows up
for stale stats and the job failed to finish in 4 hr and so multiple critical
table stats were not collected. If I am running the job as manually then can
have more degree and can finish the job in less than 4 hr. So how Oracle
allocated Degree when Degree defined for all database objects is 1 and what can
be done to update like preference or so to complete the auto job in time. Don;t
want to add layer by using cron
RgdsSanjay
