Monitoring Oracle with oratop

Intro I recently had a situation where I was troubleshooting a system that had fallen victim to some intermittent and very high load averages.  At first, there were no apparent reasons for the high load averages, so that sent me searching for some monitoring tools to help identify the issue.  Besides using OSWBB and dstat, … Continue reading

Using dstat for monitoring CPU, Memory, Disk, etc

Overview dstat is a good tool for replacing vmstat, netstat, iostat, and ifstat.  It it a very lightweight tool that can consolidate and correlate data  that  you would normally have to capture in different terminals.   Examples   RMAN Backup Throughput I’ve used dstat before in the past to monitor backup throughput over interfaces.  Of … Continue reading

Oracle GoldenGate : DB2 to Oracle

This article will demonstrate heterogeneous replication using OGG from DB2 to Oracle. 1. Pre-requisites OGG is installed on source and target systems. 2. Environment DB2 on Mainfram Z/OS Oracle Database : 3. Configuration on Source Server ( DB2 ) A. Parameter Files Place all parameter files in the $GG_HOME/dirprm directory.   Extract Capture   … Continue reading

GNU screen Command

The screen utility can be used to start a session that will be persistent if the terminal is lost, plus it also provides the ability to login from another computer simply by attaching to the screen session name.   Here are some essential commands to know: Start new session with a name and a log … Continue reading

GoldenGate 12 – Classic, Coordinated and Integrated Replicat

I. New Replicat Modes Availalble in GolgenGate 12.1 Prior to the release of version 12.1, the replicat applied transactions to the target database serially.  To achieve parallelism, tables could be split across multiple replicats to get data applied quicker and reduce lag.  Drawbacks to this approach was the manual configuration of multiple replicats, trail files, … Continue reading