Use this form to schedule updates of Oracle statistics.
For more information, refer to the Oracle system documentation.
Tasks that
use this form
Navigating
the form
The following tables provide descriptions for the controls in this form.
Buttons
|
Button |
Description |
|---|---|
|
|
Click to run the statistics. Depending on the size of the database, this function can take several hours to finish. |
Fields
|
Field |
Description |
|---|---|
|
|
Specify whether to run estimated statistics (Estimate), or actual statistics (Compute). The information generated by the Compute option is more accurate than the information generated by the Estimate option, but it takes longer to run. |
|
|
Specify how frequently you want the statistics gathering routine to run. Select Daily, Weekly, or Monthly. |
|
|
Type the date of the first day the statistics gathering should run. |
|
|
Type the time of the first day the statistics gathering should run. |
|
|
Displays the date of the last statistics calculation. |
|
|
Displays the time of the last statistics calculation. |
|
|
Displays the number of times the job has started and failed since the last successful run. |
|
|
Lists whether an attempt is made to run the job. Possible values are as follows:
|
