Re: Updating Statistics for the Data Dictionary -- Or
Date: Thu, 14 Jul 1994 21:05:31 GMT
Message-ID: <sivar.7.0010180A_at_gscrb.sandiegoca.ncr.com>
>In article <2vnagu$s8r_at_uuneo.neosoft.com> chadb_at_NeoSoft.com writes:
>>In <12a.3210.905_at_compudata.com>, barry.roomberg_at_compudata.com (Barry Roomberg)
writes:
>>>-> There are two mechanisms (that I am aware of) for updating statistics
>>>-> for the data dictionary with Oracle 7.0:
>>>->
>>>-> 1. Procedures - ANALYZE_SCHEMA, ANALYZE_OPTIONS
>>>-> 2. SQL script - CATSTAT.SQL
>>>
>>>NEITHER! Do NOT enable the cost based analyzer in Oracle 7.0
>>>Serious bugs, will not find indexes,will turn previous quick
>>>code into trash!
>>>
>>>Oracle support told me to wait for 7.1 before using it.
>>>If you accidently analyze anything to gathe r the stats,
>>>drop them NOW!
>>
>>Is this true?? I haven't heard this before... rather disturbing...
>>
>> Chad
>>
You could get an ORA-00600 error. Argument 18999 on NCR platform.
Oracle bug number for this problem is 20086.
The bug did not crash (or trash) the database or code at our site. It does give rise to run time error (as mentioned above). The workaround is to analyze the table again to delete statistics or set optimizer_goal to rule.
The error itself showed up in my case only in a multi-table join. Single table selects from the table in question appeared to work OK.
Siva Received on Thu Jul 14 1994 - 23:05:31 CEST