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@]
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@]
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7916042/viewspace-923519/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7916042/viewspace-923519/