Re: Warning: Built in 10g Stats gather is broken

From: <mccmx_at_hotmail.com>
Date: 12 Oct 2006 07:45:53 -0700
Message-ID: <1160664353.787617.217250@c28g2000cwb.googlegroups.com>

> Thank you for the bug post as you never know when you will run into
> these things.

If you do hit this, the woraround is to force a flush just before your stats gathering process each day/night.

Using something like:

exec dbms_scheduler.create_job -

(job_name=>'FLUSH_STATS_WORKAROUND_JOB',-
job_type=>'STORED_PROCEDURE',-
job_action=>'dbms_stats.FLUSH_DATABASE_MONITORING_INFO',-

start_date=>SYSTIMESTAMP, -
repeat_interval=>'FREQ=DAILY; INTERVAL=1', - enabled=>FALSE); Received on Thu Oct 12 2006 - 09:45:53 CDT