Re: Auto Stats Job

 Stefan
I will be working some of these for the table reporting high time with auto stats and will see how it can help. Will update the results Sanjay

    On Thursday, August 9, 2018, 12:18:47 PM EDT, Stefan Knecht <knecht.stefan_at_gmail.com> wrote:  

 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_at_freelists.org> 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 RgdsSanjay

-- 
//zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!Visit us at zztat.net | _at_zztat_oracle | fb.me/zztat | zztat.net/blog/  
--
http://www.freelists.org/webpage/oracle-l