Oracle Databases on virtual infrastructure have long been part of everyday life, but storage IO there is always a source of annoyance. Especially the gap between high availability and IO performance is a challenge. The product “Dell EMC RecoverPoint” is a storage replication solution via network, which is integrated as a kernel plugin in VMware vSphere/ESXi and works for individual VMDKs or volume groups.

And you really want to run Oracle on this? And in a performant way??

Oracle ACE Director Martin Klier is technically very skeptical when in spring 2021 an end customer of TGW Logistics Group expressed this requirement – deviating from all proven standards – for a project. They had to find out how realistic a solution based on RecoverPoint is for the productive operation of a fully automated warehouse system with several thousand transactions per second. So, intensive performance benchmarks and failover tests were conducted with the customer on the planned live systems.

This presentation reports on the prehistory, the scoping, and the benchmark tests. The results and their interpretation are part of the presentation, but the focus will be on the art of benchmarking in the IOPS field, independent of the tested product.

After the very successful lecture Part I had dealt primarily with parsing, this time the focus will be on crosstalk behavior in the IO field.

The structure of Oracle Database, which many of us are also emotionally familiar with, is being fundamentally renewed. It is expected that the next generations of Oracle Database and its technologies will only be available on the basis of the “Multitenant” architecture. With version 19c, this is already optionally available in the third revision – Oracle will therefore certainly build on it for the coming versions.

So it’s high time to take a detailed look at the matter: Are there differences in performance between the “classic” and “pluggable” database concepts?

Based on conducted tests and fresh impressions from practice, OLTP specialist and Oracle ACE Director Martin Klier explains where the (no longer) new architecture requires caution from a performance point of view, where a new tenant should exactly look for Noisy Neighbors, and why the location for the playground wants to be well considered.

In addition, the presentation will provide knowledge of how performance analysis works in practice in the Multitenant environment.

The structure of Oracle Database, which many of us are also emotionally familiar with, is being fundamentally renewed. It is expected that the next generations of Oracle Database and its technologies will only be available on the basis of the “Multitenant” architecture. With version 19c, this is already optionally available in the third revision – Oracle will therefore certainly build on it for the coming versions.

So it’s high time to take a detailed look at the matter: Are there differences in performance between the “classic” and “pluggable” database concepts?

Based on conducted tests and fresh impressions from practice, OLTP specialist and Oracle ACE Director Martin Klier explains where the (no longer) new architecture requires caution from a performance point of view, where a new tenant should exactly look for Noisy Neighbors, and why the location for the playground wants to be well considered.

In addition, the presentation will provide knowledge of how performance analysis works in practice in the Multitenant environment.

Thank you all folks who attended my Dublin presentations at OUG Ireland! It’s great fun to be back to the island again, and I enjoyed talking very much.

Thursday March 23rd 2017:

“42 (alternative?) Facts for Oracle Clusterware, ASM and RAC”.
Download pdf here.

Friday March 24th 2017:

“No Magic, no Jungle, no Swamp: The Oracle Alert Log”
Download pdf here.

Thanks everyone who attended the talks, you are a great crowd!
– Martin