The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in your database instance. At a certain point of time, the maintenance window closes before the statistics are gathered for all objects. Which statement is true in this scenario?

Question

Accepted Answer

D. The job is terminated and the statistics for the remaining objects are collected the next time that the The Automatic Optimizer Statistics Collection task is designed to be interruptible - when the maintenance window closes, the scheduler stops the job without error and retains all statistics already gathered. On the next maintenance window, the job identifies objects that still lack current statistics and processes them, ensuring complete coverage over time.

Answer

A. The statistics collection continues until all objects are processed. The automatic statistics job respects maintenance window boundaries and does not continue processing after the window closes, as it is governed by the Oracle Scheduler and Database Resource Manager.

Answer

B. The job is terminated and the statistics collected are restored to a time before the job started. Statistics successfully gathered before the window closed are retained and not rolled back - only objects not yet processed remain without updated statistics.

Answer

C. This produces an error and the statistics collected are locked until the next time that the maintenance No error is raised when the maintenance window closes mid-job; the job terminates gracefully and previously collected statistics are neither locked nor invalidated.

The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in your database instance. At a certain point of time, the maintenance window closes before the…

Question

Options

How the community answered

Why each option

Topics

Community Discussion