Database Configuration to Improve the Performance

If you use the Oracle database, you must 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; (For more details, see Oracle documentation).
    Note: For more details on performance tuning recommendations, see TIBCO® MDM Performance Tuning Guide.