Please note: In order to provision you with your courseware and lab access for this course QA must share several items of basic personal information with our partner (usually your full name and email address). For more information on this please visit our QA Partner data sharing page. If you have any questions or concerns please contact your QA account manager.
This Oracle GoldenGate 12c Troubleshooting and Tuning course teaches you the skills to be self-sufficient in gathering and examining 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.Learn To:Use GGSCI commands for gathering process evidence.Use the Oracle GoldenGate troubleshooting tools like Knowledge Documents, Documentation, SHOWSYNTAX parameter and the Logdump utility.Troubleshoot problems in areas such as extraction, replication, missed transactions, mapping, synchronization, SQLEXEC, file maintenance and more.Identify what causes slow startups.Monitor lag and statistics.Identify network and disk bottlenecks.Perform tuning of Manager, Extract, and Replicat.Performance TuningDiagnose and tune the latest Integrated Extract, available since release 188.8.131.52 of the Oracle RDBMS, and Integrated Replicat, available since release 12c of the Oracle RDBMSYou’ll also learn methods of Oracle GoldenGate 12c performance tuning. Expert instructors will teach you 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/replicat.PlatformsThis 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.Live Virtual Class FormatA Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.