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 -> Analyzing procedures difference?

Analyzing procedures difference?

From: Oleg Roshchin <oleg_at_ca-ib.com>
Date: Wed, 11 Aug 1999 10:53:50 +0400
Message-ID: <7or6lv$dq$1@news.netway.at> 





Hi, all!



What is the difference between DBMS_Utility.Analyze_Schema
and DBMS_Utility.Analyze_Part_Object?


In the book "Oracle8 Server Tuning" it's written to use the second
procedure and nothing about the first one.
Is the first procedure enough for analyzing everything in the
schema (to improve performance) or not?



Oracle 8.0.5.



Thanks in advance,


Oleg,


Moscow,


Russia


Received on Wed Aug 11 1999 - 01:53:50 CDT












Original text of this message













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