IMPAX 6.5.1 Server Knowledge Base home > Oracle Server home > Collecting database statistics

Gathering statistics with gather_stats_job

Oracle uses the gather_stats_job to collect Oracle optimizer statistics on various database objects in order to determine most efficient way to execute SQL statements.

Viewing the gather_stats_job schedule

Viewing maintenance window scheduling details

Changing the starting time and duration of the Oracle maintenance window

Viewing the statistics update history

Checking for failed dbms_scheduler jobs

Viewing errors produced by gather_stats_job


Topic number: 111257

Applies to: IMPAX 6.5.1 Server Knowledge Base