DBMS_UTILITY.ANALYZE_SCHEMA

PROCEDURE DBMS_UTILITY.ANALYZE_SCHEMA Specification

Specification:
procedure analyze_schema(
schema varchar2,
method varchar2,
estimate_rows number default null,
estimate_percent number default null,
method_opt varchar2 default null);

Description:
Analyze all the tables, clusters and indexes in a schema.

Input arguments:
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 this parameter is ignored.

method_opt
Method options of the following format:
[ FOR TABLE ]
[ FOR ALL [INDEXED] COLUMNS] [SIZE n]
[ FOR ALL INDEXES ][@more@]