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 designed a plan based on Oracle GoldenGate 12c to migrate the client’s on premise Oracle RAC database to a [...]

By |2017-09-20T06:32:05+00:00May 9th, 2017|Performance Wire|Comments Off on Case Study: Oracle GoldenGate for AWS – Migrate Oracle on premise to Amazon Web Services (AWS)

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 with clear evidence about the status of your database system performance and maintenance strategy.  Services Overview Performance and Maintenance Problems Identified with Recommended [...]

By |2017-09-20T06:33:04+00:00April 20th, 2017|Performance Wire|Comments Off on Database Health Check

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. Server, Storage and Network (SAN) Implementation Knowledge. Without these skills, it is impossible to properly configure and tune Oracle [...]

By |2017-09-20T06:33:14+00:00April 20th, 2017|Performance Wire|Comments Off on Oracle RAC Deployment

Database Tuning Services

Database Tuning Services Service Overview This service is 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 its considerable expertise to determine the best course of action to get your database infrastructure running [...]

By |2017-09-20T06:33:24+00:00April 20th, 2017|Performance Wire|Comments Off on Database Tuning Services

Oracle Database Migration Service

Oracle Database Migration Service Basic steps for Migrating with Oracle GoldenGate The following tasks are high level steps to migrate to a new server using near-zero downtime with GoldenGate. Create project plan Identify transformations; i.e. new partitioning, new indexes, new security, etc.. Identify new hardware Configure OS on new hardware Install Oracle 12c (target) [...]

By |2017-09-20T06:33:36+00:00April 20th, 2017|Performance Wire|Comments Off on Oracle Database Migration Service

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 and typically a consultative conversation is necessary. Services Overview Upgrade Pre-Implementation Planning A pre-implementation service, this cross functional planning [...]

By |2017-09-20T06:33:52+00:00April 20th, 2017|Performance Wire|Comments Off on Database Upgrade Service

Oracle GoldenGate Consultant

Job Title: Oracle GoldenGate Consultant Description: We're looking for Oracle GoldenGate Consultants. The ideal candidate is someone who can work autonomously and independently. You possess at least three years experience with Oracle database design, Oracle Real Application Clusters (RAC), Data Guard, database administration and knowledge of Oracle backup & disaster recovery methodologies. Additionally, you [...]

By |2018-06-15T16:49:15+00:00April 17th, 2017|Jobs|Comments Off on Oracle GoldenGate Consultant

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 GoldenGate exception table.  I didn’t know the answer but I was determined to find out.  It turns out that [...]

By |2017-09-20T08:02:59+00:00February 6th, 2017|Performance Wire|Comments Off on Capturing Before Images in the GoldenGate Exception Table

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 much of the work from your production database systems.  See Jinyu’s blog at http://jinyuwang.weebly.com/oracle-goldengate.  Using this method for splitting [...]

By |2017-09-20T08:03:14+00:00October 4th, 2016|Performance Wire|Comments Off on Splitting Oracle GoldenGate Integrated Extract and Replicat

Begin at the Beginning: Don’t use Begin Now with GoldenGate Replicat

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 problems and required some rework.  So, I wanted [...]

By |2017-09-20T08:03:24+00:00September 14th, 2016|Performance Wire|Comments Off on Begin at the Beginning: Don’t use Begin Now with GoldenGate Replicat