Re: silly dbms_stats question
- From: Yong Huang <yong321@xxxxxxxxx>
- To: Jon.Crisler@xxxxxxx
- Date: Sat, 25 Apr 2009 07:11:47 -0700 (PDT)
> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
