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.

I have noticed that expdp does take some "think time" before data actually starts getting dumped. But is this really slow? Typically, not for me. But I guess the more objects you have to export, the longer this may take. How long is "ages"?

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown