Skip to Main Content
Oracle Data Guard 11gR2 Administration : Beginner's Guide
book

Oracle Data Guard 11gR2 Administration : Beginner's Guide

by Yunus Emre Baransel, Nassyam Basha
June 2013
Beginner content levelBeginner
404 pages
9h 40m
English
Packt Publishing
Content preview from Oracle Data Guard 11gR2 Administration : Beginner's Guide

Data Guard tuning and wait events

Specific to standby database(s), we may have performance issues to read redo data and to transport over a network, redo write phase because of bad RAID configurations, Redo Apply phase because of huge redo, improper memory settings, or the issues can be with bugs. Here we will discuss some of them.

Network tuning

Standby databases will be placed geographically in different locations with WAN for high availability in case of a disaster. Even though you keep your standby database geographically far away, you should have reasonable bandwidth to avoid data lag between the primary and standby databases. It can be a bigger problem if you are using synchronous redo with AFFIRM. Consider the use of a high latency network ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Database Administration: The Essential Refe

Oracle Database Administration: The Essential Refe

David C. Kreines, Brian Laskey
Oracle Database 12c Security

Oracle Database 12c Security

Scott Gaetjen, David Knox, William Maroulis

Publisher Resources

ISBN: 9781849687904Other