Configuration Guide › Improving Performance › Improve Performance When Using Oracle

Improve Performance When Using Oracle

When using Oracle as the CA GovernanceMinder database, some tasks may take a long time to complete. To improve the performance when using Oracle, increase the Oracle REDO.log file size settings.

Also, 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).