Implementation Guide › Planning Your Implementation › Oracle Database Settings

Oracle Database Settings

When using Oracle as the CA GovernanceMinder database, some tasks may take a long time to complete. To improve the performance when using Oracle, consider the following recommendations:

• Processes: 500
• Session: 500
• REDO.log file size: 2GB each (there are 3)
• Memory: 4GB
• Tablespace datafile, varies as follows:

  TEMP—large amounts of data needs large amounts of temp space. Consider settings as follows:

  • Filesize: 1G
  • Automatically extend datafile, Increment: 200MB
  • Maximum File Size, Value: 20GB

  UNDO:

  • Filesize: 1G
  • Automatically extend datafile, Increment: 200MB
  • Maximum File Size, Value: 20GB

  USERS:

  • Filesize: 1G
  • Automatically extend datafile, Increment: 500MB
  • Maximum File Size: Unlimited

(Optional) When large amounts of data are inserted into the database, run the following statistics commands:

execute dbms_stats.gather_schema_stats('${SCHEMA}’, DBMS_STATS.AUTO_SAMPLE_SIZE);

alter system flush buffer_cache;

alter system flush shared_pool;

Note: Replace SCHEMA with the database schema name (username).