what does dbms_stat.gather_database_stats_job_proc do?

From: <emdproduction_at_hotmail.com>
Date: 12 Apr 2007 09:42:00 -0700
Message-ID: <1176396120.183303.98660@q75g2000hsh.googlegroups.com>

Dear Group,

I just upgraded my database from 9i to 10.2.0.3. Still trying to figure out whether I should remove my daily analyze script and rely on Oracle 10g's default GATHER_STATS_JOB.

From

select PROGRAM_ACTION
  from dba_scheduler_programs
  where PROGRAM_NAME = 'GATHER_STATS_PROG'; PROGRAM_ACTION

---

  dbms_stats.gather_database_stats_job_proc

But dbms_stats.gather_database_stats_job_proc does not analyze my tables. My tables are all monitored and have entries, but after I run dbms_stats.gather_database_stats_job_proc, all the entries still stay at sys.dba_tab_modifications.

Should I still keep my old analyze script, which will analze all the tables in sys.dba_tab_modifications, even after I upgrade to 10g?

Thanks Received on Thu Apr 12 2007 - 11:42:00 CDT