Oracle Table Analyze Job

This job refreshes statistics used to determine the best path or execution for a query. Statistics must be analyzed under certain circumstances, such as when the schema or the data volume has changed.

Requirements

None

Restrictions

This job cannot run concurrently with other instances of this job.

Parameters

Schema Name