IMPAX 6.5.1 Server Knowledge Base home > Oracle Server home > Collecting database statistics
The gather_and_lock_stats_job is created by IMPAX when IMPAX is installed. It's purpose is to correct statistics on a few database tables and then lock them so that they won't be updated by Oracle's gather_stats_job.
Viewing the gather_and_lock_stats_job schedule
Changing the time and duration of the gather_and_lock_stats job
Checking for failed dbms_scheduler jobs
Viewing errors produced by running gather_and_lock_stats_job
Topic number: 111254 Applies to: IMPAX 6.5.1 Server Knowledge Base |