Re: silly dbms_stats question

From: Yong Huang <>
Date: Sat, 25 Apr 2009 07:11:47 -0700 (PDT)
Message-ID: <>

> 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       

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

Original text of this message