Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Analyze

Re: Analyze

From: Ulrik Hoffmann <ulrik_at_hoffmann-kiel.de>
Date: Tue, 16 Nov 1999 20:34:49 +0100
Message-ID: <80sbqf$16mtb$1@fu-berlin.de> 





>


> >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 - 13:34:49 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US