Database Configuration to Improve the Performance

If you use the Oracle database, you should perform the following steps to improve the database performance:

Procedure

  1. Create multiple temp files of an appropriate size (not exceeding 250 MB), and assign one of the files as the default file.
  2. Create multiple groups of redo logs.
  3. Configure sga and pga with adequate size.
  4. Perform the operation gather database stats, before executing any import, using the command EXEC DBMS_STATS.gather_database_stats; (See Oracle documentation for more options and details).
    Note: See MDM Performance Tuning Guide for performance tuning recommendations for more tuning options