In the last part of this installment I'll have a brief look at the network performance measured in the Oracle DBaaS environment, in particular the network interface that gets used as private interconnect in case of RAC configuration. The network performance could also be relevant when evaluating how to transfer data to the cloud database.
I've used the freely available "iperf" tool to measure the network bandwidth and got the following results:
[root@test12102rac2 ~]# iperf3 -c 10.196.49.126
Connecting to host 10.196.49.126, port 5201
[ 4] local 10.196.49.130 port 41647 connected to 10.196.49.126 port 5201
Recently I repeated the I/O related tests on a 18.104.22.168 instance for curiosity and was surprised by the fact that I consistently got significantly better results as on 22.214.171.124 and 126.96.36.199.
Now you're probably aware that the version 12.2 so far is "cloud-only", so I can't tell / test whether the version 12.2 is generically providing that increased performance or whether Oracle has optimized the underlying stack, so that previous versions in general could also benefit from better performance if they ran on the same platform. Repeated tests with versions 188.8.131.52 and 184.108.40.206 confirmed the performance figures reported in the previous installment of this series, so as of the time of writing it's only the version 12.2 that provides the improved I/O performance.
Note that as of the time of writing only a single instance configuration was supported with version 12.2, so I wasn't able to run the tests in RAC configuration.
In this second part of this installment I'll focus on the performance figures related to I/O encountered when the corresponding tests were performed on the platform.
When running with minimum sized buffer cache, direct and asynchronous I/O enabled, the following average read-only IOPS figures were measured over a period of several days (this is the test described in part three of the "performance consistency" series) .
First, running on a 4 OCPU single instance configuration (8 CPUs / 8 cores as outlined in the previous part) with either four or eight sessions:
After having looked at the performance consistency provided by the Oracle Database Cloud offering in the previous series, I'll focus here on the raw performance figures I've measured during my tests, starting with the CPU related performance findings.
One of the first surprises is related to the fact that Oracle uses a unit called "OCPU" to specify the CPU capacity provided, which is explained here:
For people interested, here the slide desks used internally to debrief my colleagues regarding Oracle…
Below talks about my experience trying out Azure and Oracle cloud for the very first time (and at the same time).
So last night I tried for the very 1st time the Azure and Oracle Cloud. Here, I just like to share my experience. BTW I am a big fan of DigitalOcean because of its user friendly interface, very fast to setup (end to end 2 minutes w/ few button clicks), and fantastic community and HOWTOs (https://www.digitalocean.com/community/). If I have to choose a cloud dev environment provider I would still use DigitalOcean.
Now, being a newbie on both these platforms. I’m looking for a similar experience as DigitalOcean.
The cloud experience comparison is broken down to 3 categories:
For those in a desperate need to learn all 4841 database parameter variations of the…
Just created my first Extreme Performance 220.127.116.11 database in the cloud.oracle.com. So just after a…
As mentioned in the previous part of this series I've only used the "General Purpose SSD" storage type since the "Provisioned IOPS" storage was simply to expensive to me and it wasn't possible to get a trial license for that storage type.
When I was at OOW this year I saw the new (?) Oracle Live SQL…