126: Data Guard Best Practices and Tuning
Thomas Canty , ServerCare, Inc.    Biography
Diane Petersen , ServerCare, Inc.    Biography

Objectives: Identify areas that are a bottleneck in the Data Guard environment using AWR, SQL and O/S utilities.
Discuss options available to tune at hardware, O/S, Database & network level.
Present list of Best Practices with advice on what to avoid & what to implement.
Abstract: This presentation deals with identifying areas in the Data Guard environment that are bottlenecks and opportunities for tuning for faster recovery, switchover and failover. This includes methods to identify these areas and obtain benchmarks using the AWR, SQL and other O/S utilities. After identification, changes that can be made to improve the processes at different levels including the hardware, O/S, Database, Log transfer process and the Oracle Net Architecture will be discussed. A case study of a production setup will be also be presented to highlight areas where changes were made and the benefit obtained. Additionally a list of best practices with items that should be avoided and things that should be implemented will also be shown. Improvements made to Data Guard in 10gr2 and 11g will also be highlighted.

Audiernce Focus: DBA
Expertise: Intermediate
Track: Architecture
Date: Monday, April 14, 2008
Time: 3:30 PM - 4:30 PM