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






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


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 11-2005