Oracle11G data pump is used to derive a large table, the size is about 420 g, there will be two big blob field in each row, a total of 8 million rows of data, an environment use expdp export only need 3 hours and 20 minutes, another environment exp dp is used to derive the need 11 hours, don't know is what reason, thinking,
Has compared two environmental content as follows:
1. The table space debris is very normal, there is no debris too much lead to low efficiency problem
2. The migration of rows in the table, and can not be the problem of migration

CodePudding user response:

The machine configuration, memory allocation, storage, all the way,