Re: Datapump export speed
Date: Thu, 20 Feb 2020 13:53:44 +1100
Message-ID: <CAFeFPA8RMWXdN6q4QOzwU9LoyyuV0d2rMhwj-Phzs6A5vx_6VA_at_mail.gmail.com>
We have a 3.5 TB database that we datapump in about 5.5 hours.
some of it is temp, some of it is undo, some of it is indexes ..they don't take very long to export...
Compressed dumpfile size combined to 244GB
Jack van Zanen
This e-mail and any attachments may contain confidential material for the sole use of the intended recipient. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of this e-mail or any attachment is prohibited. If you have received this e-mail in error, please contact the sender and delete all copies. Thank you for your cooperation
On Tue, Feb 18, 2020 at 5:31 AM Ahmed Fikri <gherrami_at_gmail.com> 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
>
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 20 2020 - 03:53:44 CET