The title suggests a negative statement of using a Public Cloud. Well, it isn’t. I’m convinced the Cloud is the next best thing, with huge advantages for businesses. But companies should be aware of what they choose. A lot of providers, including Oracle, are pushing us to the cloud, Public, Private or Hybrid. And make us believe that a public cloud will be an inevitable extension to our on-premises environment. Moving your weblogic and (more...)
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 (more...)
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 (more...)
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.IOPS
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 (more...)
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:
So one "OCPU" is supposed to represent one core (more...)
12 Days of #Cloud: Day 12 After playing with Oracle Database Cloud Service (DBaaS) for past several days, I have mixed feeling. I like quite a lot of features and the amount of automation went into the product. For example, creating an RAC instance and creating a Data Guard instance by picking a check box […]
12 Days of #Cloud: Day 11 After a few failed attempts, I was successful in creating a Data Guard DBaaS Instance. Since I was playing with a trial account, the resources were limited. I guess when I had another database running, there is not much storage left to create two instances in Data Guard configuration. […]
12 Days of #Cloud: Day 10 In a previous post, I talked about enabling backups on a #DBaaS instance where backups were disabled when the instance was created. Today I show you how to create a database with Cloud Backup enabled at the time of creating the instance. To store backups on the Oracle Cloud, […]
12 Days of #Cloud: Day 9 I have a 12.1. Database Cloud Instance, which comes with several patches including July 2016 PSU. The dbaascli cloud tool can be used to query and apply patches. Before we use dbaascli, let’s check what the Cloud interface shows. Choose the DBaaS instance and view details. The “Administration” tile shows […]
12 Days of #Cloud: Day 8 It is very easy to stand up a new DBaaS instance as a replica or clone of an existing instance. In this demo, I am going to create a new instance as a copy of CLDB4ACED DBaaS instance. First, need to create a snapshot using the DBaaS instance menu. […]
For people interested, here the slide desks used internally to debrief my colleagues regarding Oracle…
12 Days of #Cloud: Day 7 There are three types of storage expansion possible on Oracle #DBaaS instance. 1. Increase Default File Systems Increasing the default file systems that hold data files (/u02), FRA and backup (/u03) is easy. These file systems can be increased by using the menu item “Scale Up / Down Service” […]
12 Days of #Cloud: Day 6 When I created the #DBaaS instance, did not create a backup policy. I chose the backups as “None”. Now that some work has been done on the database, would like to create an adhoc backup as well as want to schedule regular local disk backups. On-demand backup can be performed […]
A few weeks ago the 12.2 Oracle Database was released on the cloud. I immediately set an account and got my 12.2 DBaaS setup. This was a relatively painless process and quick.
For me I wanted to test out all the new Oracle Advanced Analytics new features and the new features in SQL Developer 4.2 that only become visible when you are using the 12.2 Database.
When you are go to (more...)
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 (more...)
For those in a desperate need to learn all 4841 database parameter variations of the…
Just created by first Extreme Performance 188.8.131.52 database in the cloud.oracle.com. So just after a…
This part of the series is supposed to cover the results of I/O related tests performed on the Amazon RDS Oracle cloud instance.
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.
Now one key aspect of the "General Purpose SSD" storage (more...)
There are situations where approximate results are superior than exact results. Typically, this is the case when two conditions are met. First, when the time and/or resources needed to produce exact results are much higher than for approximate results. Second, when approximate results are good enough. Approximate results are for example superior in case of exploratory queries or when results are displayed in a visual manner that doesn’t convey small differences.
Version 12.1.0. (more...)