|
[oracle-l]
||
[Date Prev]
[05-2005 Date Index]
[Date Next]
||
[Thread Prev]
[05-2005 Thread Index]
[Thread Next]
Analyze not working properly in 7.3.4
- From: "Smith, Ron L." <rlsmith@xxxxxxx>
- To: "Oracle-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 2 May 2005 15:10:28 -0500
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
|
