ABCS: Create a lookup

| May 14, 2017
When using reference data, a lot of times you want to use a list of values or a data lookup to specify what values can be selected. Within ABCS you can create lookups to fill in this requirement. When creating a new data field, for example when creating a Business Object under a table as we did in my previous blog entry, you can select the data type to be a reference.

For my (more...)

ABCS: Creating the Data Model

| May 6, 2017
One of the powers of ABCS is that it generates a Data Model for you on the fly, based on your UI needs. For the developers, do not worry, you can also do this in an expert mode or edit and adjust it afterwards, more on that later in this blog series.
We are going to build a data model to hold all the data about the sessions being held on the Tech Conference.

This (more...)

ABCS: The First Adjustments

| May 3, 2017
Now that you are ready to go, let's make a few simple adjustments to the application. We want to brand the app with a logo & title and we will set up the home page, which will basically be the disclaimer of this not being the official OGh Tech Experience website.

When in your application, make sure you are in edit mode and check out the header. You will see it says 'COMPANY.LOGO' where (more...)

ABCS: Getting started

| May 2, 2017
Getting started with ABCS is very easy, go to, your starting point for all Oracle Cloud products. For every Oracle Cloud product applies that you can get a free trial through there. This trial is a great starting point for getting to know the product. If you go to the Platform section you will see Application Builder in the list. Once you went to ABCS specific site, you can register for (more...)

What Oracle DBAs Need to Learn in Oracle Cloud Platform?

The transition from Oracle on-premises DBA to Oracle Cloud DBA is imminent for many of us. In fact, IMHO; the existing Oracle DBAs would have to manage database both on-premises and in cloud for a long time.

So what Oracle DBA needs to learn in Oracle Cloud Platform? If you visit the Oracle Cloud website, it's a mouthful and more. Its very easy to get bogged down as there are lots of things to (more...)

Is Oracle Database in Cloud PaaS, IaaS, SaaS, or DBaaS?

Question: Is Oracle Database in Cloud PaaS, IaaS, SaaS, or DBaaS?
  • If you install and manage Oracle database in cloud by yourself, then you are using it on IaaS.
  • If you are just using it in cloud without installing or managing it, then it's PaaS.
  • If you are configuring the database instance and have access to it through SQL*Net, then its DBaaS. 
  • SaaS not really relevant when it comes to Oracle (more...)

Use PSM to push your application to ACCS

| Mar 6, 2017
To push an application on the Application Container Cloud Service (ACCS) from the terminal, you can use the Oracle product 'PaaS Service Manager Command Line Interface' (PSM CLI). PSM CLI is a tool to help you with scripting tasks you want to do against several Oracle Clouds. The steps to push your application to the Oracle Cloud are not that complex, in short:

  1. We create a container in Storage Cloud for our application.
  2. We put (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 instance for curiosity and was surprised by the fact that I consistently got significantly better results as on and

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.


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

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.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 DBaaS database available

Just created by first Extreme Performance database in the So just after a…