Datapump export speed
From: Ahmed Fikri <gherrami_at_gmail.com>
Date: Mon, 17 Feb 2020 19:29:58 +0100
Message-ID: <CANkb5P1wSPXgm35M109pCzFuAmnSOQW69DAyAEP6w3_Xp4H9wQ_at_mail.gmail.com>
Hi all,
Date: Mon, 17 Feb 2020 19:29:58 +0100
Message-ID: <CANkb5P1wSPXgm35M109pCzFuAmnSOQW69DAyAEP6w3_Xp4H9wQ_at_mail.gmail.com>
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 Mon Feb 17 2020 - 19:29:58 CET