Oracle GoldenGate 12c: Troubleshooting and Tuning

DesTech
Remote
Schedule

Partner
Remote
Schedule

Course DateStart TimeEnd TimeTime ZoneLocationDaysPrice


O12C: GOLDTT

Oracle GoldenGate 12c: Troubleshooting and Tuning

This Oracle GoldenGate 12c Troubleshooting and Tuning training teaches you how to gather and examine evidence; you 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.

Duration: 4 Days

Prerequisites

  • Familiarity with the Oracle Database

Audience

  • Data Warehouse Administrators
  • Database Administrators
  • Implementation Consultants
  • System Administrators
  • System Architects
  • System Integrators

Learning Objectives

  • Use GGSCI commands for gathering process evidence
  • Identify what causes slow startups
  • Monitor lag and statistics
  • Identify network and disk bottlenecks
  • Perform tuning of Manager, Extract and Replicat
  • Diagnose and tune the latest Integrated Extract and Integrated Replicat
  • Troubleshoot problems in areas such as extraction, replication, missed transactions, mapping, synchronization, SQLEXEC, file maintenance and more
  • Use the Oracle GoldenGate troubleshooting tools like Knowledge Documents, Documentation, SHOWSYNTAX parameter and the Logdump utility
  • Describe solutions for the most common problems

Topics

  • 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
Right Menu IconMENU