ABCS: Maintain Security & Anonymous Access

| Jun 13, 2017
Since the application of the tech17 is now live here (disclaimer: for the official information about the OGh Tech17, go to, it is time to adjust the security settings. By default when trying to access the application you need to login to the Oracle Cloud to be able to access the application.
To give public access, I will create an anonymous role and add certain pages to the anonymous role, after (more...)

ABCS: Go Live with your Application

| Jun 11, 2017
When you are done developing the first version of your application, you might want to go live with it. Within ABCS there are a couple of steps build in to publish your application to the public. Before you can do this, you first have to go through a Stage environment where you can check the functionality of your application before publishing the application.

To do this, in the main menu we you choose the option (more...)

ABCS: Import data from CSV

| Jun 6, 2017
In this use case, I do not let the user fill the data for the application through data entry forms, but rather I use the data that is available for the OGh Tech Experience 2017, this data is in a csv file that I want to upload to display the tracks within the application.

When opening the hamburger menu on the top left, you can leave the Page Designer and go to other parts of (more...)

Oracle Database on Hyper-scale Public Cloud – License Questions!

We all know, on January 23, 2017, Oracle updated the Licensing Oracle Software in the Cloud Computing Environment document. The gist of the announcement was “When counting Oracle Processor license requirements in Authorized Cloud Environments, the Oracle Processor Core Factor Table is not applicable“. So, if you are running Oracle database on x86 Intel platform on-premise, […]

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

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

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…

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…

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