Re: Analyze_schema - What method?

From: Mladen Gogala <mgogala_at_yahoo.com>
Date: Thu, 25 Mar 1999 02:34:39 GMT
Message-ID: <7dc7c0$bko$1@nnrp1.dejanews.com>

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 Wed Mar 24 1999 - 20:34:39 CST