Re: what does dbms_stat.gather_database_stats_job_proc do?

On Apr 12, 12:42 pm, emdproduct..._at_hotmail.com wrote:
> 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

Maybe you want to look at the documentation?

This has been covered multiple times of course in http// asktom.oracle.com or in cdos which you could search thru instead of asking again. Received on Thu Apr 12 2007 - 14:19:59 CDT