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!
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.
+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.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
