Database Administration (MOSC)

MOSC Banner

Oracle Dataguard Maximum Availability Performance

edited Nov 5, 2018 5:12AM in Database Administration (MOSC) 4 commentsAnswered

We are doing performance testing for an application  which uses Oracle database (12.1.0.2) with a dataguard setup in Maximum availability protection mode (SYNC/AFFIRM).

The primary and standby database are residing in 2 seperate regions in Microsoft Azure environment.

The performance results with this setup is not very good.

We tried changing the protection mode of the dataguard setup to maximum performance (ASYNC) and  the performance has improved considerably.

Can the network between the 2 Azure regions where the databases reside be the reason for the degraded performance in Maximum availability mode?

Is there any setting in Dataguard or sqlnet.ora that can help improve the dataguard performance in maximum availability mode as the client requirement is to have minimum data loss.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center