RE: silly dbms_stats question

From: Crisler, Jon <>
Date: Fri, 24 Apr 2009 13:12:24 -0400
Message-ID: <56211FD5795F8346A0719FEBC0DB0675042C7BAF_at_mds3aex08.USIEXCHANGE.COM>

I have found that in many cases this is disabled. When I clone a db with RMAN, the resulting clone has this job disabled even though the original it was enabled.

When I did a migration from a 2-node RAC / ASM to a single node with filesystems, it is also disabled. But its simple to enable again:  

Exec sys.dbms_scheduler.enable( '"SYS"."GATHER_STATS_JOB"' );  

From: Sweetser, Joe [] Sent: Friday, April 24, 2009 12:57 PM
To:; Crisler, Jon
Cc: oracle-l-freelists
Subject: RE: silly dbms_stats question  

Indirectly related, don't forget that Oracle automatically gathers stats by default in 10g.  

Go here: #i41282  

To see (among other things) this:  

This job is created automatically at database creation time and is managed by the Scheduler. The Scheduler runs this job when the maintenance window is opened. By default, the maintenance window opens every night from 10 P.M. to 6 A.M. and all day on weekends.  


[] On Behalf Of Jared Still Sent: Friday, April 24, 2009 10:35 AM
To: Crisler, Jon
Cc: oracle-l-freelists
Subject: Re: silly dbms_stats question

On Fri, Apr 24, 2009 at 9:29 AM, Crisler, Jon <> wrote:

        My information was that dbms_stats does not update the last_analyzed column of dba_tables / user_tables, and this affected all versions of 10g, but was fixed in 11g. However your test seems to contradict my information, but I have tested this many times and found it to be true, even on I wonder if there is a patch that changed this behavior ?

Is there a database you can duplicate it on?

Possibly platform dependent?

Our databases are all on Windows or Linux.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist    

Received on Fri Apr 24 2009 - 12:12:24 CDT

Original text of this message