dbms_stats already has built-in what you need:
https://docs.oracle.com/database/121/ARPLS/d_stats.htm#ARPLS68674
Just use set_table_prefs to set the desired degree for the largest tables.
Stefan
On Thu, Aug 9, 2018 at 4:15 AM, Sanjay Mishra <dmarc-noreply@xxxxxxxxxxxxx>
wrote:
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
Rgds
Sanjay
