Oracle

set state=apply-off and datafile consistency

By Franck Pachot . In a standby database (or in any database you recover) do you think the recovery uses buffer cache? And when you stop the apply in a standby database, do you think the datafiles are in a(…)

Performing an initial load with GoldenGate (2) – expdp/impdp

The last post in this series outlined on how to do an initial load of the target database using the “file to replicat” method: Installing and patching Oracle GoldenGate 12c to the latest release(…)

Performing an initial load with GoldenGate (1) – file to replicat

The first post in this series outlined on how to install and patch Oracle GoldenGate to the latest release.The second post explained how to create a sample replication with Oracle GoldenGate: Installing and patching Oracle GoldenGate 12c(…)

Oracle Standard Edition Two

By Franck Pachot . Look at the Oracle Download page: Standard Edition is there in 12.1.0.2 - more than one year after the release of the patchset for Enterprise Edition. It's a new name - SE2(…)

Setting up a sample replication with GoldenGate

The first post in this series outlined on how to install and patch Oracle GoldenGate to the latest release: Installing and patching Oracle GoldenGate 12c to the latest release In this post I’ll look in how to(…)

Installing and patching Oracle GoldenGate 12c to the latest release

As more and more customers ask for expertise in Oracle GoldenGate this blog post is the first in a series and outlines how to install Oracle GoldenGate 12c and how to patch it to the latest release on Oracle Linux(…)

DataBase Cloud Service performance – CPU

By Franck Pachot . In the previous blog post I've measured the physical i/o performance, with SLOB. We can run the same with a small size of data and a large buffer cache(…)

DataBase Cloud Service performance – IOPS

By Franck Pachot . Having a database in the cloud is very nice. You add storage with a few clicks. You don’t have to think about the storage type (DAS, SAN, NAS), size of disks, stripe size, SSD, etc.

SLOB in the Cloud: how to check Cloud Services performance

By Franck Pachot . You buy resources on the Cloud, but they are mutualized, thanks to virtualization. Are you sure you have the resources you paid for? When it comes to Oracle databases there are 3 ways to test(…)

SCN synchronization in distributed transactions

By Franck Pachot . You have lot of db links between two databases, you think they are not used but want to be sure. It's not difficult. When doing distributed transactions (which means running a transaction that involves remote databases(…)