RE: DBMS_UTILITY ?

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Tue, 13 Mar 2001 11:05:46 -0800
Message-ID: <F001.002CB462.20010313110638@fatcity.com>

>-----Original Message-----
>From: Bunyamin K.Karadeniz [mailto:bunyamink_at_havelsan.com.tr]
>Sent: mardi, 13. mars 2001 01:01
>
>dbms_utility.analyze_schema ( '&OWNER', 'ESTIMATE', NULL, 5 ) ;
>
>1) wHAT DOES THAT PROCEDURE DO? I could not find it in the documentation.
>Does it analyze all tables
>in a given user.?? I mean Does it do  the below?
>2) Then what is NULL and 5 is used for ?
>Analyze table scott.xxx estimate statistics; // repeating for all tables of user.

I agree with (was it Mr. Goulet?) whoever said "buy the book 'Oracle Built-in Packages' by Feuerstein, Dye and Beresniewicz, O'Reilly Press". But you can also find the dbms_utility package mentioned in the documentation. Online documentation can be found at the Oracle Technology Network

http://otn.oracle.com

From the following manual

Oracle8i Supplied Packages Reference
Release 8.1.5
A68001-01
Chapter 53
DBMS_UTILITY ANALYZE_SCHEMA procedure
This procedure analyzes all the tables, clusters, and indexes in a schema.

Syntax
DBMS_UTILITY.ANALYZE_SCHEMA (

   schema           VARCHAR2, 
   method           VARCHAR2, 
   estimate_rows    NUMBER   DEFAULT NULL, 
   estimate_percent NUMBER   DEFAULT NULL, 
   method_opt       VARCHAR2 DEFAULT NULL);

...
schema
Name of the schema. 
 
method
One of ESTIMATE, COMPUTE or DELETE.  If ESTIMATE, then either estimate_rows or estimate_percent must be non-zero.   
estimate_rows
Number of rows to estimate. 
 
estimate_percent
Percentage of rows to estimate. If estimate_rows is specified, then ignore this parameter.   
method_opt
Method options of the following format:

[ FOR TABLE ]
[ FOR ALL [INDEXED] COLUMNS] [SIZE n]
[ FOR ALL INDEXES ]

---

any ignorant comments made are the sole responsibility of J. R. Kilchoer and should not reflect adversely upon my employer.

 
Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com
  Received on Tue Mar 13 2001 - 13:05:46 CST