Database Configuration to Improve the Performance
If you use the Oracle database, you must perform the following steps to improve the database performance:
- Procedure
- Create multiple temp files of an appropriate size (not exceeding 250 MB), and assign one of the files as the default file.
- Create multiple groups of redo logs.
- Configure
sga
andpga
with adequate size. - 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.