I disabled or even dropped it at the last place where I had the
authority to do so.
a) I was operating in a mixed Oracle 9.2 / 10.1 environment and
preferred to use the same procedure for gathering statistics in both.
b) I needed more control over which tables get analyzed, or rather
which tables would not.
c) While it was active, I got errors mailed to me from my alert_log
sweeper almost every morning about conflicts and rather than
investigating them I decided "3rd strike and you're out".
At 06:38 PM 5/17/2006, David Turner wrote:
I'm curious if anyone is intentionally using the dbms_stats.gather_database_stats_job_proc scheduled in 10g. Has anyone replaced the job because of limitations with it? From what I've read it looks reasonable but if someone has found any failings with it I would appreciate to hear about them.
Regards
-- //www.freelists.org/webpage/oracle-l
