Analyze
| Task Type: |
Database Utiility |
| Configurable: |
Yes |
| Host Dependent: |
No |
| Schedule Dependent: |
No |
Description
The Analyze task analyzes Oracle tables.
Configuration
The <AnalyzeConfig> element must contain one or more <Schema> elements; each <Schema> element identifies one or more schemas to analyze. The <Schema> element is configured with the following attributes:
| Attribute |
Required |
Description |
| NAME |
Yes |
The name of a schema to analyze. Multiple schemas are indicated by using '*' as a wildcard. For example, setting NAME to 'DEP*' causes all schemas starting with 'DEP' to be analyzed. |
| SAMPLE |
Yes |
Specifies the sample method used to analyze tables. When the value is set to 'COMPUTE', all rows are analyzed. When set to an integer value, the given number of rows are analyzed. When set to a percentage (e.g. 45%), the given percentage of rows are analyzed. |
| FOR |
No |
Specifies a 'FOR' clause to use in analyze statements. (e.g. 'ALL INDEXED COLUMNS') |
Each <Schema> element may contain one or more <Object> elements. When no <Object> elements are provided, the task analyzes all tables for the given schema(s). <Object> elements are used to identify specific sets of tables to analyze within schemas. <Object> elements are configured with the following attributes:
| Attribute |
Required |
Description |
| NAME |
Yes |
The name of a table to analyze. Multiple tables are indicated by using '*' as a wildcard. For example, setting NAME to 'JOB*' causes all tables starting with 'JOB' to be analyzed. |
| SAMPLE |
Yes |
Specifies the sample method used to analyze tables. When the value is set to 'COMPUTE', all rows are analyzed. When set to an integer value, the given number of rows are analyzed. When set to a percentage (e.g. 45%), the given percentage of rows are analyzed. |
| FOR |
No |
Specifies a 'FOR' clause to use in analyze statements. (e.g. 'ALL INDEXED COLUMNS') |
Each <Schema> element may also contain one or more <ObjectExclude> elements. <ObjectExclude> elements identify one or more tables that should be excluded from the analyze process. <ObjectExclude> elements are configured with the following attribute:
| Attribute |
Required |
Description |
| NAME |
Yes |
The name of a table to exclude. Multiple tables are indicated by using '*' as a wildcard. For example, setting NAME to 'WORK*' causes all tables starting with 'WORK' to be excluded. |
