[contact-form-7 404 "Not Found"]

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

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

Using ShowSyntax in Oracle GoldenGate 12.2

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 about to apply.  SHOWSYNTAX is used in interactive mode and does not work [...]

By |2017-09-20T08:03:39+00:00September 13th, 2016|Performance Wire|Comments Off on Using ShowSyntax in Oracle GoldenGate 12.2