Help!!!!!! New Windows server 2012 R2 datacenter edition, the installation oracle11g impdp import unusually slow, especially with CLOB type fields of table

The data backup is more than 130 G, which contain there are about 100 G with clob type field in the table, when the import on the new server 1 to 2 M per second, the whole import takes 10 hours, time is too long, the speed is too slow, but in an old can reach more than 70 M per second when the test machine is imported, after an hour or so guide,

O people!!!!!

CodePudding user response:

All configured memory?

CodePudding user response:

The server's physical memory size is 512 g, ORACLE installation configuration, please help to give a suggestion, I check it again,

CodePudding user response:

Guide CLOB or with TTS

CodePudding user response:

If you want to know why the new environment on slow, wait for events to watch

CodePudding user response:

You can try it according to the measured exp and imp for lob faster than expdp

CodePudding user response:

Has been solved, server installation RAID card configuration has a problem,