Poor performance using data pump export
Hi
I'm currently looking into utilising data pump internally due to the reported performance benefits over the old export/import utilities. We're using Oracle 10.2.0.4, which we've installed on three Windows servers. Each server has two databases configured on them - one ascii one unicode.
The issue that we have is as follows:
On one of the databases we compared the times for running exp and expdp on the command line and found that exp took 5 minutes to run, whereas expdp took 18 minutes for the same schema. The resulting dump file from expdp was then imported into a new schema on the same database and this took 3 and a half minutes. However, when running expdp through Enterprise Manager the export only took 2 minutes.
I'm currently looking into utilising data pump internally due to the reported performance benefits over the old export/import utilities. We're using Oracle 10.2.0.4, which we've installed on three Windows servers. Each server has two databases configured on them - one ascii one unicode.
The issue that we have is as follows:
On one of the databases we compared the times for running exp and expdp on the command line and found that exp took 5 minutes to run, whereas expdp took 18 minutes for the same schema. The resulting dump file from expdp was then imported into a new schema on the same database and this took 3 and a half minutes. However, when running expdp through Enterprise Manager the export only took 2 minutes.
0