Prev: Enterprise Grid Control - Agent Configuration Assistant
Next: Oracle user group
From: emdproduction on 12 Apr 2007 12:42
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

From: hpuxrac on 12 Apr 2007 15:19
On Apr 12, 12:42 pm, emdproduct...(a)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.

 | 
Pages: 1
Prev: Enterprise Grid Control - Agent Configuration Assistant
Next: Oracle user group