Đang chuẩn bị liên kết để tải về tài liệu:
Oracle Built−in Packages- P98

Oracle Built−in Packages- P98: Ah, for the good old days of Version 1.0 of PL /SQL! Life was so simple then. No stored procedures or functions and certainly no packages. You had your set of built−in functions, like SUBSTR and TO_DATE. You had the IF statement and various kinds of loops. With these tools at hand, you built your batch−processing scripts for execution in SQL*Plus, and you coded your triggers in SQL*Forms 3.0, and you went home at night content with a good day's work done. | Appendix A What s on the Companion Disk Collects column statistics for all columns and scalar attributes. The size is the maximum number of partitions in the histogram with a default of 75 and a maximum of 254. FOR ALL INDEXED COLUMNS SIZE N Collects column statistics for all indexed columns in the table. The size is the maximum number of partitions in the histogram with a default of 75 and a maximum of 254. FOR ALL INDEXES Collects statistics for all indexes associated with the table. 10.1.2.1.1 Example Here is an example of a request to this program to analyze all columns in my database BEGIN DBMS_UTILITY.ANALYZE_DATABASE ESTIMATE 100 50 FOR ALL COLUMNS SIZE 200 END 10.1.2.2 The DBMS_UTILITY.ANALYZE_SCHEMA procedure This procedure analyzes all of the tables clusters and indexes in the specified schema. The header for the procedure follows PROCEDURE DBMS_UTILITY.ANALYZE_SCHEMA schema IN VARCHAR2 method IN VARCHAR2 estimate_rows IN NUMBER DEFAULT NULL estimate_percent IN NUMBER DEFAULT NULL method_opt IN VARCHAR2 DEFAULT NULL Parameters are summarized in this table. Parameters Description schema The name of the schema containing the object for which you wish to compute statistics. If NULL then the current schema is used. This argument is case-sensitive. method Action to be taken by the program. ESTIMATE DELETE and COMPUTE are accepted values explained later . estimate_rows The number of rows to be used to perform the statistics estimate. Cannot be less than 1. Used only if method is ESTIMATE. estimate_percent The percentage of rows to be used to perform the statistics estimate. Ignored if estimate_rows is non-NULL. Must be between 1 and 99. Used only if method is ESTIMATE. method_opt The method option indicating which elements of the object will be analyzed. Here are the valid entries for the method argument and the resulting activity when you pass one of these values they must be enclosed in single quotes COMPUTE Exact statistics are computed based on the entire