| Course Date | Start Time | End Time | Time Zone | Location | Days | Price |
|---|
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
