Re: Analyze_schema - What method?

The whole point of analyzing your tables is to gather statistics for the optimizer. I run analyze_schema as part of my batch processes after rebuilding indexes.

-Dean

On Thu, 25 Mar 1999 02:34:39 GMT, Mladen Gogala <mgogala_at_yahoo.com> wrote:

>In article <36F8E626.94B996C_at_zv.fhg.de>,
> Reinhard Wahl <wahl_at_zv.fhg.de> wrote:
>> Hi there,
>>
>> does anybody know what method does procedure DBMS_UTILITY.ANALYZE_SCHEMA
>> use?
>>
>> When I try: EXEC DBMS_UTILITY.ANALYZE_SCHEMA(user, NULL); --NULL or
>> ESTIMATE is documented
>>
>> I receive an ORA-1490: invalid ANALYZE-Command
>>
>> When I try: EXEC DBMS_UTILITY.ANALYZE_SCHEMA(user, 'COMPUTE');
>>
>> it runs, but it is much faster than to ANALYZE one bigger table in the
>> same schema.
>> I don't trust it.
>>
>> I use RDBMS 7.3.4.x and PL/SQL 2.3.4.x
>>
>> Thanx Reinhard
>>
>Gruess Gott!
>Versuchen sie mit 'exec dbms_utility.analyze_schema(user,'COMPUTE');' oder
>'exec dbms_utility.analyze_schema(user,'ESTIMATE');'
>
>Mladen Gogala
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Mar 25 1999 - 20:33:04 CST