Infrastructure at your Service

SLOB Archives - Blog dbi services

Franck Pachot

Spectre/Meltdown on Oracle Public Cloud UEK – PIO

By | Oracle | 2 Comments

The Spectre and Meltdown is now in the latest Oracle UEK kernel, after updating it with ‘yum update': [opc@PTI ~]$ rpm -q –changelog kernel-uek | awk ‘/CVE-2017-5715|CVE-2017-5753|CVE-2017-5754/{print $NF}’ | sort | uniq -c 43 {CVE-2017-5715} 16 {CVE-2017-5753} 71 {CVE-2017-5754} As I did on the previous post on AWS, I’ve run quick tests on the Oracle Public Cloud.  

 
Read More
Franck Pachot

Google Cloud Platform instances and Oracle Database

By | Cloud, Database Administration & Monitoring | No Comments

When it comes to choose a cloud instance to run Oracle Database, you want to be able to run your workload on the minimum CPU cores. This is why in a previous post I measured how many logical reads per seconds can be achieved with a SLOB workload, on AWS which is often the first considered, and will probably do it on Azure in the future. I did the same on the Oracle Cloud which…

 
Read More
Franck Pachot

Running SLOB on Exadata Express Cloud Service

By | Database Administration & Monitoring | One Comment

The Exadata Express Cloud Service is a managed PDBaaS: Oracle is the system admin and the CDB database administrator, you are the PDB administrator. You connect with a local user, PDB_ADMIN, which is no SYSDBA privilege but has a PDB_DBA which has nearly all DBA rights, but with some features disabled by lockdown profile. I have no worry about the performance on this service: it is an Exadata X5 half rack bare metal (my guess),…

 
Read More
Franck Pachot

Exadata X-5 Bare Metal vs. OVM performance

By | Database Administration & Monitoring | No Comments

The Exadata X5 can be installed Bare Metal or Virtualized. The latter one, Oracle VM allows to create multiple clusters on one machine, is more complex for installation and for storage capacity planning. But it allows a small flexibility on options licencing. Those are the real challenges behind the choice. However, when we talk about virtualization, most of questions are about the overhead. Last week, we did some tests on same machine with different configuration,…

 
Read More
Franck Pachot

Extended clusters and asm_preferred_read_failure_groups

By | Database Administration & Monitoring | One Comment

When you have 2 sites that are not too far you can build an extended cluster. You have one node on each site. And you can also use ASM normal redundancy to store data on each site (each diskgroup has a failure group for each site). Writes are multiplexed, so the latency between the two sites increases the write time. By default, reads can be done from one or the other site. But we can,…

 
Read More
Franck Pachot

Testing Oracle on exoscale.ch

By | Database Administration & Monitoring | One Comment

My last post came from a discussion at SITB with exoscale. They are doing Cloud hosting with datacenters in Switzerland. In Switzerland a lot of companies cannot host their data outside of the country, which is a no-go for the big Cloud providers. After the discussion they gave me a coupon for a trial IaaS instance. And if you follow my blog you should know that when I have a trial access, there are good…

 
Read More
Franck Pachot

DataBase Cloud Service performance – IOPS

By | Development & Performance, Oracle | No Comments

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. But do you have the performance you expect? I’ve tested I/O in the Cloud that just opened for Europe, so that I get an image of performance when nobody’s there. SLOB If you want to test IOPS, the tool is…

 
Read More
Franck Pachot

SLOB in the Cloud: how to check Cloud Services performance

By | Database Administration & Monitoring, Oracle | No Comments

You buy resources on the Cloud, but they are mutualized, thanks to virtualization. Are you sure ou have the resources you paid for? When it comes to Oracle databases there are 3 ways to test performances: Run an application, or a simulation of an application, such as the excellent SwingBench from Dominic Giles Run low-level calibration tools, such as Orion that simulate database, good when you have no database yet Or run something in the…

 
Read More