Re: silly dbms_stats question

From: Yong Huang <yong321_at_yahoo.com>
Date: Sat, 25 Apr 2009 07:11:47 -0700 (PDT)
Message-ID: <543205.73514.qm_at_web80608.mail.mud.yahoo.com>

> dba_tables column "last_analyzed" does not reflect dbms_stats.

Could it be that your tables are partitioned and were analyzed with ANALYZE command before? See Note:258687.1 "Last_analyzed Column Does Not Change After Analyzing tables"? Mixing ANALYZE with DBMS_STATS actually has other problems as well.

Yong Huang

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

Received on Sat Apr 25 2009 - 09:11:47 CDT

This message: [ Message body ]
Next message: Kumar Madduri: "Dataguard setup at DR site"
Previous message: fairlie rego: "Re: 11g Patchset 1 Changes"
Maybe in reply to: Crisler, Jon: "silly dbms_stats question"
Next in thread: Thomas Day: "Re: silly dbms_stats question"
Reply: Thomas Day: "Re: silly dbms_stats question"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message