Re: Analyze

From: Immo Zech <i.zech_at_lineas.de>
Date: Thu, 8 Oct 1998 12:15:28 GMT
Message-ID: <F0ICq2.830@lineas.de>

Hello,

>Josef Huber wrote:
>> Is there a command with that i can analyze a entire schema ?

you can do just this by executing the stored procedure

sys.dbms_utility.analyze_schema

It takes the following parameters:

PROCEDURE ANALYZE_SCHEMA

 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 SCHEMA                         VARCHAR2                IN
 METHOD                         VARCHAR2                IN
 ESTIMATE_ROWS                  NUMBER                  IN     DEFAULT
 ESTIMATE_PERCENT               NUMBER                  IN     DEFAULT
 METHOD_OPT                     VARCHAR2                IN     DEFAULT

Bye
        Immo

Received on Thu Oct 08 1998 - 07:15:28 CDT