Re: silly dbms_stats question
From: Jared Still <jkstill_at_gmail.com>
Date: Fri, 24 Apr 2009 09:35:04 -0700
Message-ID: <bf46380904240935i320bdad2o3668bbd7b793790a_at_mail.gmail.com>
On Fri, Apr 24, 2009 at 9:29 AM, Crisler, Jon <Jon.Crisler_at_usi.com> wrote:
Date: Fri, 24 Apr 2009 09:35:04 -0700
Message-ID: <bf46380904240935i320bdad2o3668bbd7b793790a_at_mail.gmail.com>
On Fri, Apr 24, 2009 at 9:29 AM, Crisler, Jon <Jon.Crisler_at_usi.com> 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
> 10.2.0.3. 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
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Apr 24 2009 - 11:35:04 CDT