D85725 | Oracle GoldenGate 12c: Troubleshooting and Tuning | Training Course | Oracle. Skip to main Content

Oracle GoldenGate 12c: Troubleshooting and Tuning

  • Course Code D85725
  • Duration 4 days

Course Delivery

Additional Payment Options

  • GTC 40 inc. VAT

    GTC, Global Knowledge Training Credit, please contact Global Knowledge for more details

Public Classroom Price

eur2.745,00

excl. VAT

Request Group Training Add to Cart

Course Delivery

This course is available in the following formats:

  • Public Classroom

    Traditional Classroom Learning

Request this course in a different delivery format.

Course Overview

Top

This Oracle GoldenGate 12c Troubleshooting and Tuning training teaches you how to gather and examine evidence; you’ll also learn to solve case problems, diagnose their cause and find methods of resolution. Each of these practices challenges you to diagnose and troubleshoot the issue using GoldenGate software.

Benefits to You

By enrolling in this course, you'll develop deeper knowledge of Oracle GoldenGate 12c performance tuning methods. Expert instructors will teach you how to identify the causes of slow startups, evaluate lag statistics and solve network and disk bottlenecks. Utilize all of the existing GoldenGate tools, such as GGSCI and Logdump, the health check scripts and the Streams Performance Advisor (UTL_SPADV) to troubleshoot system issues occurring to both classic extract/replicat and integrated extract/replicate.

Explore Platforms

This training is on a Linux platform; however many of the troubleshooting techniques are equally applicable to a Windows or iSeries platform. The databases used for source and target are Oracle 12cR1. Many of the techniques are also applicable to DB2, SQL Server, MySQL, etc.

 

Course Schedule

Top

Target Audience

Top
  • Data Warehouse Administrator
  • Database Administrators
  • Implementation Consultant
  • System Integrator
  • System Administrator

 

Course Objectives

Top
  • Monitor and tune performance
  • Gather evidence to help troubleshoot problems
  • Use troubleshooting tools
  • Familiarize with the latest tools to troubleshoot Integrated Extract/Replicat
  • Describe solutions for the most common problems


Course Content

Top
  • Gathering Evidence
  • Oracle GoldenGate Troubleshooting Tools
  • Basic and Startup Problems
  • Data Extraction Problems
  • Data Replication Problems
  • Missed Transactions
  • Mapping and Synchronization Problems
  • SQLEXEC, File-Maintenance, and Other Problems
  • "Classic" Performance Tuning
  • "Integrated" Performance Tuning
  • "Integrated" Capture and Delivery Troubleshooting

 

Course Prerequisites

Top

Oracle GoldenGate 12c: Fundamentals for Oracle

 

Cookie Control toggle icon