YES. Oracle DATABSE has default, scheduled job "gather_stats_job" that analyses stats on a daily basis during the maintenance window time.

There are two scheduled activities related to the collection of Oracle "statistics":

• AWR statistics: Oracle has an automatic method to collect AWR "snapshots" of DATA that is used to create elapsed-time performance reports.
• Optimizer statistics: Oracle has an automatic job to collect statistics to help the optimizer make intelligent decisions about the best access method to fetch the DESIRED rows.

This job can be disabled with this command: EXEC dbms_scheduler.disable(’SYS.GATHER_STATS_JOB’);
Oracle collects optimizer statistics for SQL VIA the default of autostats_target = auto.

YES. Oracle databse has default, scheduled job "gather_stats_job" that analyses stats on a daily basis during the maintenance window time.

There are two scheduled activities related to the collection of Oracle "statistics":

This job can be disabled with this command: exec dbms_scheduler.disable(’SYS.GATHER_STATS_JOB’);
Oracle collects optimizer statistics for SQL via the default of autostats_target = auto.