IN BSAE, is the GATHER_SCHEMA_STATS job necessary

In most cases, no. With Oracle 10.x it was added as part of the database so there is no need for a job to gather stats any longer. Oracle handles if for you. The job can be disabled.

Leave a Comment