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