Configure Scheduled Tasks¶
This page describes the tasks that are supposed to be scheduled when configuring a new installed system before taking it into operation.
In the form General/Schedule Tasks make sure to set or verify the foundation predefined Scheduled Tasks.
Scheduled task | Description | Scheduling recommendation | Comment |
---|---|---|---|
Gather Statistics | This task gathers statistics about all tables and indexes in the Application owner / Info Owner schemas. Optionally it gathers statistics for Oracle dictionary tables and Oracle Fixed Objects (Dynamic Performance Tables). It is recommended to gather statistics about Oracle dictionary tables. Statistics of Oracle Fixed Objects recommended to be gathered once after a major installation (fresh install / upgrade) and not always. The statistics collected is used by Oracle cost based optimizer to produce the best execution plans for all queries. Read more on statistics here |
Normally this schedule should be disabled. | Oracle gathers statistics automatically - by default at 22:00 every evening. Try to avoid running other IO intense jobs at 22, or ask a DBA to move the Oracle Maintenance Window. |
Heavy Cleanup | Heavy cleanup remove data from Print Jobs, Archived Print Jobs, History log data, Scheduled Tasks and Event messages. | Once a night | Scheduled upon installation |
Light Cleanup | Light cleanup removes data from Background Jobs, foundation Session information. | Every tenth minute | Scheduled upon installation |
Validate Indexes | Validates indexes and checks for rebuild index candidates. Note: This script can cause database blocking locks if used when database activity is high. |
Once a month Note: Schedule with caution. There should be very little activity in the database when this job runs. |
|
Rebuild Indexes | Rebuilds bad indexes checked by Validate Indexes. Should run after Validate Indexes. Note: This script can cause database blocking locks if used when database activity is high. |
Once a month Note: Schedule with caution. There should be very little activity in the database when this job runs. |
|
Foundation1 Monitoring | Checks all active Monitoring entries against their warning limits. Triggers an event if warning limit is reached. | Once a day | |
Validate Timespan Users | Checks if the user account should be activated or deactivated dependent of an interval set on each users. | Once a night (at midnight) | Scheduled upon installation |
Shrink LOB segments | Shrink LOB segments to reduce the tablespace size. Note: This job is only available when running Oracle Enterprise Edition. Note: This script can cause database blocking locks if used when database activity is high. |
Once a week Note: Schedule with caution. There should be very little activity in the database when this job runs. |
|
Update of rowkey columns | Incremental update of rowkey columns for tables not having rowkey enabled. Described in detail in Activate and deactivate rowkey. (for older upgraded systems only) | Recurring at time periods of low system load. | When full rowkey coverage is attained the job may be disabled. The job may also be run during planned downtime. |