分析对象DBMS_UTILITY.ANALYZE_SCHEMA(8i以前版本)

DBMS_UTILITY.ANALYZE_SCHEMA

This routine will generate statistics on an individual schema level. It is used for analyzing all tables, clusters and indexes.

It takes the following parameters:

• schema - Name of the schema
• method - Estimation method, COMPUTE or ESTIMATE. DELETE can be used to remove statistics.
• estimate_rows - The number of rows to be considered for estimation.
• estimate_percent - The percentage of rows to be considered for estimation.
• method_opt - Method options. Generate statistics FOR TABLE, FOR ALL COLUMNS, FOR ALL INDEXED COLUMNS, FOR ALL INDEXES.

If the ESTIMATE method is used, then either estimate_rows or estimate_percent should be specified; these actually specify the sample size to be considered.

Call syntax

e.g.: Computing statistics for a schema

e.g.: Estimating statistics for a schema, sample size is 1024 row.

e.g.: Estimating statistics for FA schema, sample size is 10 percent of rows.

e.g.: Deleting statistics for FA schema

e.g.: Estimating statistics with 5 percent rows for all indexes in a schema.

e.g.: Estimating statistics with 5 percent rows for columns with indexes in a schema.

e.g.: Estimating statistics with 5 percent rows for all columns in a schema.

e.g.: Estimating statistics for all tables in a schema.

e.g.: Proper sample size should be given, otherwise ORA-01493 is encountered.

ORA-06512: at line 1

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7478833/viewspace-402624/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7478833/viewspace-402624/