Month: February 2010

Oracle GoldenGate Tutorial 9 – Monitoring GoldenGate

The following tutorial will briefly discuss the different commands we can use to monitor the GoldenGate environment and get statistics and reports on various extract and replicat operations which are in progress. More details can be obtained from Chapter 19 of the Oracle GoldenGate Windows and Unix Administration guide – Monitoring GoldenGate processing. Information on […]

Improving your SQL Queries

Greetings! You probably found this page either through a Search Engine, an aggregator that doesn’t delete blogs for inactivity, or possibly from a site with a very long blogroll, so let me introduce myself to you.My name is Robert Vollman. Those who …

Why does the size of my ORACLE_HOME increase?

Recently I discovered that the size of an ORACLE_HOME for a given release varies from machine to machine although the machines are of the same architecture and run the same operating system. A small difference in size can be explained by the fact that one ORACLE_HOME was re-linked in the past while the other wasn’t, […]

ILO Elapsed Time module available

For anyone who is interested in recording the process and cpu elapsed via instrumentation, I have made the elapsed time collection module I’m currently using available at the Expert Oracle Practices: Database Administration from the Oak Table source code download site.The first step is to download the Instrumentation Library for Oracle (ILO) version 2.3 from SourceForge.Next, install ILO per the

ILO Elapsed Time module available

For anyone who is interested in recording the process and cpu elapsed via instrumentation, I have made the elapsed time collection module I’m currently using available at the Expert Oracle Practices: Database Administration from the Oak Table source code download site.The first step is to download the Instrumentation Library for Oracle (ILO) version 2.3 from SourceForge.Next, install ILO per the

Oracle GoldenGate Tutorial 7 – configuring DDL synchronization

In addition to providing replication support for all DML statements, we can also configure the GoldenGate environment to provide DDL support as well. A number of prerequisite setup tasks need to be performed which we willl highlight here. Run the following scripts from the directory where the GoldenGate software was installed. The assumption here is […]

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569