Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Analyze not working properly in 7.3.4

Analyze not working properly in 7.3.4

From: Smith, Ron L. <rlsmith_at_kmg.com>
Date: Mon, 2 May 2005 15:10:28 -0500
Message-ID: <270A0BDDFDE54E41B78F0F06D82A66B8013467B4@okcexg3.kmg.com> 





I run an Analyze estimate on all my tables and indexes every weekend.=20
But for some reason the LAST ANALYZED column of USER_TAB_COLUMNS as well
as LAST ANALYZED in USER TABLES=20


indicates that the tables and indexes have not been analyzed in a year.
The statistics on each object appear to be correct.




Am I looking in the wrong place?



Thanks!


Ron

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


Received on Mon May 02 2005 - 16:15:56 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US