Re: Analyze and Data Dictionary views on Oracle 7.3.4.0.1

From: David <darussell_at_email.msn.com>
Date: Thu, 10 Sep 1998 22:06:25 +0100
Message-ID: <u0MJ47P39GA.257@upnetnews02.moswest.msn.net>

NEVER EVER analyze the data dictionary UNDER ANY CIRCUMSTANCES. If you must analyze the SYS schema use dbms_system.analyze_schema because it avoids dynamic tables such as FET$/UET$...., but this should NEVER be required because Oracle optimized the dictionary for the rule based optimizer or add hints as required.

Regards
David Russell

Roman Gelfand wrote in message <6t8m24$ns8$1_at_news.monmouth.com>...
>There are no error messages. However catalog tables and views get
>corrupted.
>
>
>Winnie Liu wrote in message <6t7jmt$t6h_at_sjx-ixn10.ix.netcom.com>...
>>Every time you analyze the tables or indexes... Oracle had to updated
>>certain dictionary views and tables. But what do you mean by the
dictionary
>>views get screwed up? What kind of error message do you get?
>>
>>Winnie
>>
>>Roman Gelfand wrote in message <6t6pgd$kd8$1_at_news.monmouth.com>...
>>>It seems like every time we run analyze on Oracle 7.3.4.0.1, the data
>>>dictionary views get screwed up. Is this really what is taking place?
Is
>>>there any way to solve it?
>>>
>>>
>>
>>
>
>
Received on Thu Sep 10 1998 - 16:06:25 CDT