If you use the Oracle database, you should 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 and
pga with adequate size.
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