All articles

DataBase Cloud Service performance – Network

By Franck Pachot . In previous posts, I've installed SLOB on the Cloud Services, measured IOPS and(…)

Join transitive closure and query simplification considerations

Yesterday, I had a discussion with one of my friend who works with Oracle about some different behaviours between each query optimizer against one particular query. You can read his blog post and get the repro script here. I(…)

If we stop the GoldenGate replication: Will transactions running at that time on the source will be replicated before replication stops?

This is the next post on this GoldenGate series: Installing and patching Oracle GoldenGate 12c to the latest release Setting up a sample replication with GoldenGate Performing an initial load with(…)

Windows 10 – I tried and came back

By Franck Pachot . I've tried Windows 10 one month ago, and I had to roll back because VirtualBox failed to create host-only interfaces. Today, it forced me to upgrade again, so I tried a little further... and finally rolled(…)

Measuring IOPS on XtremIO

By Franck Pachot . Today, we can put our database on very efficient storage. EMC XtremIO is one of them. In this blog post, I'll show how to look at the IO performance from Enterprise Manager, Orachrome Lighty, and XtremIO(…)

Using GoldenGate event actions to suspend replication for end of day reporting

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

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 12c duplicate in cluster fails with ORA-65500

I had to perform a duplicate database between 2 ODAs and was always facing an ORA-65500 at the begin of the RMAN operation. Looking a bit deeper in the log outputs pointed me out that it was due to some(…)