Re: silly dbms_stats question

From: Jared Still <jkstill_at_gmail.com>
Date: Fri, 24 Apr 2009 09:22:56 -0700
Message-ID: <bf46380904240922s6330037sb381a01a2fbf6635_at_mail.gmail.com>

On Fri, Apr 24, 2009 at 8:49 AM, Crisler, Jon <Jon.Crisler_at_usi.com> wrote:

> I know that dba_tables column “last_analyzed” does not reflect
> dbms_stats. DBA_TAB_MODIFICATIONS tracks monitoring for dbms_stats, but it
> does not track when dbms_stats was run.
>
> Could you be more specific on that?

Version, etc?

Just ran this test on a 10.2.0.3 database on RH EL4, and last_analyzed is being updated by dbms_stats as I would expect:

select table_name, last_analyzed
from user_tables
where table_name = 'AT1'
order by last_analyzed
/

begin

   dbms_stats.gather_table_stats(user,'AT1'); end;
/

select table_name, last_analyzed
from user_tables
where table_name = 'AT1'
order by last_analyzed
/

09:20:01 ordevdb01.radisys.com - js001292_at_dv11 SQL> _at_s5

TABLE NAME                     LAST_ANALYZED
------------------------------ -------------------
AT1                            08/22/2006 22:00:02

1 row selected.

PL/SQL procedure successfully completed.

TABLE NAME                     LAST_ANALYZED
------------------------------ -------------------
AT1                            04/24/2009 09:20:03

1 row selected.

I've been using last_analyzed for several versions, and haven't seen the problem you mentioned.

Or if it was there, I just missed it. :)

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Apr 24 2009 - 11:22:56 CDT