Re: Datapump export speed

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Mon, 17 Feb 2020 14:56:30 -0600
Message-ID: <CAJvnOJZiimNfaGYFHHeYkeQ06Q7boaP=rQawktRFd+LQo79iOA_at_mail.gmail.com>



As Mladen says, there is no way to determine this within even an order of magnitude without testing. Another factor is the number of LOBs, depending on the oracle version LOBs cant take a lot longer to export than other data. If you are not on enterprise edition, you can simply run multiple streams with different parameter files to improve the speed.

On Mon, Feb 17, 2020 at 1:40 PM Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> The speed depends on many factors:
>
> 1. Hardware: type and architecture of the machine, number of
> processors, SGA size
> 2. Database version and configuration
> 3. Degree of parallelism
> 4. Where are you storing the export file? Rotational disks, SSD,
> another DB (db_link)
> 5. Other arguments (EXCLUDE=TABLE_STATISTICS, compression)
>
> My advice would be to do dry runs. Tests are the best way. If you are
> looking for a consultant, send me a private email and we can negotiate the
> price.
>
> Regards
> On 2/17/20 1:29 PM, Ahmed Fikri wrote:
>
> Hi all,
>
> Without knowing all db settings it is not easy to respond this question,
> but could someone tell me how much time approximativelly needed to export 4
> TB db using datapump?
>
> A college told me that 200 GB / hours is possible. One should adjust some
> parameters, excluding statistics, parallel etc.
> (Sure the physical infrastructure should help )
>
> Second: is using dblink will be faster? The servers are in the same
> location.
>
> Regards
>
>
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Feb 17 2020 - 21:56:30 CET

Original text of this message