Re: Automatic statistics don't work on 10g (job and statistics level OK)

Hi Juan,

Yes, that is what I'm saying. When the amount of DDL change against the table since last analyze is more than 10% it will re-gather stats.

Mogens

Juan Carlos Reyes Pacheco wrote:

>Hi Mogens, could you please extend your answer I didn't understood
>exactly what are you saying. Are you saying oracle only gather
>statistics if is 10% modified through gather_stats_job?
>Thanks
>
>
>
>

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