Hi, the built-in “Gather Statistics” job (aka, Database_Sys.Execute_Analyze_Schema__) is taking over 12 hours to run. Since it’s a built-in job, does anyone have any ideas why it would be taking so long?
It was scheduled to run every day - they never changed it from the initial install - and I just changed it to run once a month, which should help, but any thoughts?
Thanks!
+18
Hi
It may be due to the configuration of the parameters that the job is using. Can you provide those?
e.g. the percentage and the schemas being included.
Nick
+18
Hi
How long Gather Statistics job takes to complete can depend on the database size & performance, batch queue where the background job belongs, job’s schedule, parameters etc.
You need to investigate each of these areas to determine where the slowness lies.
The param used is “Compute” and under Advanced, “Schema Owner - Application Owner” . I couldn’t find anywhere where it defined what these were and which to use.
Also, Hi, Nick.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
