Oracle GoldenGate 11g Troubleshooting and Tuning

This Oracle GoldenGate 11g Troubleshooting and Tuning course teaches you to gather and examine evidence to solve cases. Each of the practices challenges you to diagnose and troubleshoot issues using GoldenGate software.

Learn To:

• Use Oracle GoldenGate troubleshooting tools like Knowledge Documents, Documentation, SHOWSYNTAX parameter & the Logdump utility.
• Troubleshoot Extract and Replicat problems, mapping problems and synchronization problems.
• Identify causes of slow startups.
• Monitor lag and statistics.
• Identify network and disk bottlenecks.
• Perform tuning of key components.
• Use GGSCI commands to gather process evidence.

Oracle GoldenGate 11g Performance Tuning

This course helps you explore methods of Oracle GoldenGate 11g performance tuning by identifying the causes of slow startups, evaluating lag statistics and solving network and disk bottlenecks. You'll also learn to utilize all of the existing GoldenGate tools, like GGSCI and Logdump, to troubleshoot system issues.

Audience

• Database Administrators
• System Administrator
• Technical Consultant
• Support Engineer

Course Topics Gathering Evidence

• GGSCI commands
• Viewing Checkpoint Details
• Evaluating a Process Report
• Evaluating a Log Sample
• Gather and evaluate systems logs

Troubleshooting Tools

• SHOWSYNTAX overview, usage and output
• Logdump overview
• Utilizing the key commands and functionality of Logdump

Startup Problems

• GoldenGate configuration
• Operating system configuration
• Permissions
• Slow startup

Extraction Problems

• Diagnosing a slow Extract
• Solving the issue when Extract abends
• Solving the issue when the Data Pump Extract abends

Replication Problems

• Replicat is not moving or abends
• Replicat abends with Error 509
• Preventing Replicat from exiting

Missed Transaction Problems

• Transactions not being processed
• Including missed transactions

Mapping and Synchronization Problems

• Solve mapping problems such as missed definitions and colum mappings
• Syncrhronization issues such as out-of-sync rows, tables without keys, character sets, and DML on target tables

SQLEXEC Problems

• SQL does not execute
• Tracing SQLEXEC problems
• File Maintenance Problems
• Time differences
• Unusable indexes
• Too many open cursors

Performance Tuning

• Builing the object record for speeding up the startup
• Monitoring lag statistics
• Identifying bottlenecks such as lag, network issues, and disk reads
• Tuning Extract and Replicat for optimal performance

Course Objectives

• Use troubleshooting tools
• Describe solutions for the most common problems
• Monitor and tune performance
• Gather evidence to help troubleshoot problems