Public Cloud consequences with an Oracle environment

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...)

Oracle Database Cloud (DBaaS) Performance – Part 4 – Network

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...)

Oracle Database Cloud (DBaaS) Performance – Part 3 – Storage – 12.2 Update

Recently I repeated the I/O related tests on a 12.2.0.1 instance for curiosity and was surprised by the fact that I consistently got significantly better results as on 11.2.0.4 and 12.1.0.2.

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...)

Oracle Database Cloud (DBaaS) Performance – Part 2 – Storage

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...)

Oracle Database Cloud (DBaaS) Performance – Part 1 – CPU

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...)

12th Day of #Cloud: Thoughts

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: Exploring #DBaaS with Data Guard

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: Backup #DBaaS to Cloud Container

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: Apply Patch to #DBaaS Instance

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: Cloning #DBaaS Instance

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. […]

eProseed Oracle Open World 2016 debrief – Oracle Database & Oracle Management Cloud

For people interested, here the slide desks used internally to debrief my colleagues regarding Oracle…

12 Days of #Cloud: Adding Storage to #DBaaS Node

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: Enabling #DBaaS Backups

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 […]

12.2 DBaaS (Extreme Edition) possible bug/issue with the DB install/setup

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...)

Azure and Oracle Cloud – My First Time

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...)

Oracle 12cR2: Database parameters

For those in a desperate need to learn all 4841 database parameter variations of the…

Oracle 12.2.0.1 DBaaS database available

Just created by first Extreme Performance 12.2.0.1 database in the cloud.oracle.com. So just after a…

Oracle Database Cloud (DBaaS) Performance Consistency – Part 7

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...)

Approximate Aggregate Transformation (AAT)

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...)

Oracle Database Cloud (DBaaS) Performance Consistency – Part 6

In the next parts of this series I'll have a look at the results of similar performance consistency tests performed on a comparable Amazon RDS Oracle cloud database instance.

Let's start with the configuration used, which was an Amazon RDS "db.m4.2xlarge" instance - the latest RDS generation available at time of testing. This is an 8 VCPUs resp. Hyper Threads / 4 cores configuration with 32GB of RAM.
As storage I've used (more...)