Disable automatic database statistics generation by Oracle

About this task

If you do not intend to use the Oracle AutoTask infrastructure to manage the collection of database table statistics, then disable the generation of database statistics by Oracle before you install Guidewire PolicyCenter. If Oracle database statistics is enabled after the installation of PolicyCenter, do the following:

Procedure

  1. Disable Oracle database statistics generation.
  2. Delete the schema statistics.
  3. Gather full database statistics using the Guidewire DBStats batch process.