1) Use parallel

2)While mentioning the dump file, use _%U.dmp (generates multiple dumps), which will be faster.

3)Increase the stream pool size
alter system set streams_pool_size=2G;
alter system set “_disable_streams_pool_auto_tuning”=TRUE;

4)Use only the system user to import and export

5) While import disable the auto optimizer stats collection.

BEGIN
DBMS_AUTO_TASK_ADMIN.DISABLE(
client_name => ‘auto optimizer stats collection’,
operation => NULL,
window_name => NULL);
END;
/

Recommended Posts

Start typing and press Enter to search