Does a standby slow down Oracle imp?

1 vote

1 answer

459 views

                          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

Asked by Ould Abba (157 rep)

Feb 3, 2013, 02:24 PM
Last activity: Feb 4, 2013, 03:06 PM

Does a standby slow down Oracle imp?

Related Questions