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

From: Mogens Nørrgaard <mln@xxxxxxxxxxxx>
To: Oracle-L Freelists <Oracle-L@xxxxxxxxxxxxx>
Date: Mon, 28 Nov 2005 12:39:57 +0100

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

References:

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

Re: Automatic statistics don't work on 10g (job and statistics level OK)
From: Juan Carlos Reyes Pacheco

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

Other related posts: