|Added to KB||09-Jul-2020|
Named Resources: Database
Affected Domain Objects
All business objects, globally
Only Oracle dictionary tables (user_tables, user_indexes, ...)
Is Site Specific
Analyzes the database schema to optimize the database query performance. Disabling the Oracle
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.
What Happens Switched Off
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
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.
Product To Version
The information provided in the Knowledge Base may not be applicable to all systems and situations. Intershop Communications will not be liable to any party for any direct or indirect damages resulting from the use of the Customer Support section of the Intershop Corporate Web site, including, without limitation, any lost profits, business interruption, loss of programs or other data on your information handling system.