Re: Datapump export speed

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)

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
>
>
>

--
http://www.freelists.org/webpage/oracle-l