RE: Analyze Statistics on 7.3.4

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Tue, 10 May 2005 12:35:46 -0400
Message-ID: <5A14AF34CFF8AD44A44891F7C9FF41050395B8B7@usahm236.amer.corp.eds.com>

Wasn't this same question just brought yesterday?

The last_analyzed column was pretty new back in 7.3 days and Oracle development failed to properly update the last analyzed value in _tab_columns.

HTH -- Mark D Powell --

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Smith, Ron L. Sent: Tuesday, May 10, 2005 10:27 AM
To: oracle-l_at_freelists.org
Subject: Analyze Statistics on 7.3.4

I have an old production application running on 7.3.4 that will be replaced later this year.

About a year ago, I change from running Analyze Compute Statistics to Analyze Estimate Statistics on the tables. The Analyze is run on all tables every weekend.

But now, when I query the LAST_ANALYZED from USER_TAB_COLUMNS it shows a date LAST_ANALYZED of about a year ago. This seems odd because if I look at the statistics for each object, they appear to be current. (record count, etc...)

Can I trust the Analyze Estimate or not? Is there a way to be sure?

Thanks!
Ron
--

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

http://www.freelists.org/webpage/oracle-l Received on Tue May 10 2005 - 12:40:31 CDT