# Does a standby slow down Oracle imp?

I have Oracle 10gR2 installed on Redhat Linux 5.4 on two servers (primary and physical standby).

When I import data into the primary server while the standby is started it takes too long to complete (didn't wait for it to finish). When I shutdown Oracle on the standby server it completes in 15 minutes.

Is this really due to standby? How can I speed up this slow imp? Here is the command line used:

imp userid=/ file=base.dmp ignore=yes log=log1.log


• They should hardly influence each other assuming that the network between the servers has enough bandwidth to allow the archiver to copy the logs over the network faster than the primary can generate them at peak utilization. If the network between the servers doesn't have enough bandwidth and the import process generates a bunch of REDO, the primary could easily be stuck waiting on network transfers to the standby server. – Justin Cave Feb 4 '13 at 15:58