>-----Original Message-----
>From: Bunyamin K.Karadeniz [mailto:[EMAIL PROTECTED]]
>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
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
