Performance Wire
Case Study: Oracle GoldenGate for AWS – Migrate Oracle on premise to Amazon Web Services (AWS)
Case Study: Oracle GoldenGate for AWS – Migrate Oracle on premise to Amazon Web Services (AWS) A leading content streaming service required the live-migration of its critical 24X7 billing system with near-zero downtime. Performance Tuning Corporation…
- May 09
- 2 mins read
Database Health Check
Database Health Check Offering at a Glance The PTC Database Health Check Service has been designed and approved by world renowned database experts. The offering is a quick, easy, and targeted service focused on arming you…
- Apr 20
- < 1 min read
Oracle RAC Deployment
Oracle RAC Deployment Performance Tuning Corporation has successfully implemented more than 300 Oracle Real Application Cluster (RAC) systems on UNIX, Linux and Windows. Below are some important things to consider before engaging your critical resources….
- Apr 20
- 3 mins read
Database Tuning Services
Database Tuning Services are focused on determining the root cause or causes of existing Oracle or MS SQL Server database performance problems. At the end of this engagement a remediation proposal will be provided. PTC will apply…
- Apr 20
- 2 mins read
Oracle Database Migration Service
Oracle Database Migration Service Basic steps for Migrating with Oracle GoldenGateThe following tasks are high level steps to migrate to a new server using near-zero downtime with GoldenGate. Create project planIdentify transformations; i.e. new partitioning,…
- Apr 20
- 2 mins read
Database Upgrade Service
Database Upgrade Service Offering at a Glance The Database Upgrade Service is intended for all customers looking to upgrade existing databases to the latest version. Cost and duration are dependent on a variety of factors…
- Apr 20
- 2 mins read
Capturing Before Images in the GoldenGate Exception Table
Capturing Before Images in the Oracle GoldenGate Exception Table I was recently asked by a customer of mine how to capture both the before image and the after image of a conflict in the Oracle…
- Feb 06
- 3 mins read
Splitting Oracle GoldenGate Integrated Extract and Replicat
Splitting Oracle GoldenGate Integrated Extract and Replicat During a recent meeting with Jinyu Wang of Oracle I learned that, in Oracle GoldenGate, running an Integrated Extract and Integrated Replicat from a remote system can offload…
- Oct 04
- 4 mins read
Begin at the Beginning: Don’t use Begin Now with GoldenGate Replicat
Begin at the Beginning: Don’t use Begin Now with GoldenGate Replicat In the past few weeks, I have seen a few cases where an Oracle GoldenGate replicat has been created incorrectly which has caused a few…
- Sep 14
- 4 mins read
Using ShowSyntax in Oracle GoldenGate 12.2
In order to understand what Oracle GoldenGate is doing under the covers you can use the parameter SHOWSYNTAX. The SHOWSYNTAX parameter allows you to see the actual SQL statement is that the replicat process is…
- Sep 13
- 3 mins read