Enabled

False

Locally Enabled

Locally Enabled

Analyzes the database schema to optimize the database query performance. Disabling the Oracle GATHER_STATS_JOB entirely is not recommended because it also gathers dictionary stats (SYS/SYSTEM schemas). Therefore changing the value of AUTOSTATS_TARGET to ORACLE instead of AUTO using dbms_stats.set_param('AUTOSTATS_TARGET', 'ORACLE') is recommended.

The following file can be used to adjust the settings: IS_SHARE/system/config/cluster/database.properties.

Depending on storefront traffic and batch tasks like data import this job should be executed at least once a day.

In production systems with heavy storefront traffic some tables (basket, etc) grow.

If this job does not run, querying these tables may take a lot of time, because the Oracle optimizer works with wrong statistics.

The job calls the stored procedure gather_schema_stats, which can be executed manually in the database using SQL*Plus:

SQL> set serveroutput on size 10000000
SQL> exec gather_schema_stats
[2012-07-05 08:48:28.665 +00:00] gather_schema_stats: started.
[2012-07-05 08:49:00.736 +00:00]                user: ...
[2012-07-05 08:49:00.736 +00:00]    estimate_percent: 5
[2012-07-05 08:49:00.736 +00:00]             cascade: TRUE
[2012-07-05 08:49:00.736 +00:00]          method_opt: FOR ALL COLUMNS SIZE 1
[2012-07-05 08:49:00.736 +00:00]             options: GATHER
[2012-07-05 08:49:00.736 +00:00]        block_sample: FALSE
[2012-07-05 08:49:00.737 +00:00]              degree: 0
[2012-07-05 08:49:00.737 +00:00]         granularity: AUTO
[2012-07-05 08:49:00.737 +00:00]       no_invalidate: FALSE
[2012-07-05 08:49:00.737 +00:00]               force: FALSE
[2012-07-05 08:49:00.737 +00:00] gather_schema_stats: finished, elapsed time:
32.07 sec.

PL/SQL procedure successfully completed.

Only disable this job when you handle this another way.

Depending on storefront traffic or batch operations (e.g., import) this job should be executed at least once a day.