Re: Overhead of Dataguard

From: Stefan Koehler <>
Date: Tue, 14 Nov 2017 09:57:31 +0100 (CET)
Message-ID: <>

Hey Jack,
you may want to have a look at this white paper:

It is about Oracle 10g and there have some enhancements in the meantime but it includes impact analysis / results.

Best Regards
Stefan Koehler

Independent Oracle performance consultant and researcher Website:
Twitter: _at_OracleSK

> Jack van Zanen <> hat am 14. November 2017 um 04:21 geschrieben:
> Hi All
> I was wondering if anyone had done any testing on the overhead of Dataguard on the primary system?
> We would like to setup dataguard for one of our systems and the business can most likely not accept a performance degredation of the nightly batch job.
> Now I understand that we have to turn on force logging and depending on the amount of nologging that is happening in the batch this could be a considerable overhead, I am just wondering besides this what the impacts are in maximum performance and maximum availability and maximum protection mode. I can turn on force logging without having to set up dataguard.
> Let's assume for now that the network can keep up with the changes.....
> Jack van Zanen

Received on Tue Nov 14 2017 - 09:57:31 CET

Original text of this message