Re: Analyze
From: Ulrik Hoffmann <ulrik_at_hoffmann-kiel.de>
Date: 1999/11/16
Message-ID: <80sbqf$16mtb$1_at_fu-berlin.de>#1/1
Date: 1999/11/16
Message-ID: <80sbqf$16mtb$1_at_fu-berlin.de>#1/1
>
> >How can i analyze all tables/indexes that belong to a user ?
>
> SQL> exec dbms_utility.analyze_schema('<schema>', 'COMPUTE')
>
> hope this helps
> Reinhard
you better use ESTMATE instead of COMPUTE if you have very large tables which doesnt't fit in the temporary tablespace.
Bye
Uli
Received on Tue Nov 16 1999 - 00:00:00 CET