Re: Analyze

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