Re: Auto Stats Job

hi Sanjay,

Can you show more details of what you are seeing. When running the job manually how much degree are you seeing? Have you configured the resource manager?

Rgds,
Sachin Pawar
https://twitter.com/sach_pwr

On Wed, Aug 8, 2018 at 5:17 PM 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
>
> Rgds
> Sanjay
>

--
http://www.freelists.org/webpage/oracle-l