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. Before you run any imports, use the EXEC DBMS_STATS.gather_database_stats command to perform the gather database stats operation. (For more details, see Oracle documentation).
    Note: For more details on performance tuning recommendations, see TIBCO® MDM Performance Tuning Guide.