Re: datapump, expdp, is very slow

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. Received on Wed Nov 15 2006 - 05:46:50 CST