Re: datapump, expdp, is very slow

From: Snonck <snonck_at_snog.com>
Date: Thu, 16 Nov 2006 08:35:24 +1000
Message-ID: <455b95b9$0$5109$afc38c87@news.optusnet.com.au>

Charles Hooper wrote:

> Snonck wrote:

>> Are many people using datapump (expdp) on solaris 10, oracle 10.2.0.2 or
>> on other platforms?
>>
>> I find that it is really slow! It sits there for ages doing nothing,
>> well nothing obvious. I was doing some tracing and found that it was
>> doing the following for every single user in the database!
>>
>> SELECT COUNT(*) FROM ALL_USERS WHERE USERNAME = :B1
>>
>> I guess it must have a good reason for doing it?
>>
>> It also does lots of other SQL like the above statement. Once it starts
>> doing the table dumps it is quite good, especially the parallelism, but
>> at the beginning and end when it does the meta data it takes ages (I
>> realise that it does the meta data sequentially but still it takes
>> ages)! Especially when you have over a hundred thousand users in the
>> database.
>>
>> I'm going to do some comprehensive tests later on, so might post some
>> timings then.

> 
> Are you executing Data Pump through Enterprise Manager or the command
> line?  If you are executing from the command line, are you instructing
> Data Pump to estimate disk space usage?
> See:
> http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_export.htm
> 
> Charles Hooper
> PC Support Specialist
> K&M Machine-Fabricating, Inc.
> 

I don't use ESTIMATE_ONLY and the default is n. So this isn't a problem.

With ESTIMATE I have tried both options and it is still as slow.

I am using it through the command line. Received on Wed Nov 15 2006 - 16:35:24 CST