Some impressions from Oracle Analytics Cloud–taken from keynote at Oracle OpenWorld 2017

In his keynote on October 3rd during Oracle OpenWorld 2017, Thomas Kurian stated that the vision at Oracle around analytics has changed quite considerably. He explained this change and the new vision using this slide.


All kinds of data, all kinds of users, many more ways to present and visualize and machine generated insights to complement human understanding.

The newly launched Analytics Cloud supports this vision.


Zooming in on Data Preparation:


And from cleansed (more...)

Oracle OpenWorld 2017 : It’s a Wrap

Time for a final post to summarize the craziness that was OpenWorld 2017. 🙂

For me the story of this year’s OpenWorld was the emphasis on humans doing stuff where humans add value, rather than doing boring crap that can be automated.

The obvious thing people will jump on is the Autonomous Database announcement, which I’ve written about already, but the story follows through many aspects of the conference.

The interest in chatbots is quite high (more...)

Oracle OpenWorld 2017 : The Journey Home

For some reason I thought I was flying home early today. I wasn’t. The flight was 15:00.

I had put myself on an waiting list for an upgrade, that I didn’t get. Unknown to me, and contrary to the advice from the Lufthansa agent I spoke to on the phone, this happened to mean I also lost my aisle seat for the 11+ hour flight home, since I was advised not to check-in online. Flying (more...)

Oracle Linux: How to change from uek to Red Hat compatible kernel

After a standard installation of Oracle Linux the uek kernel is bootet by default (unbreakable enterprise kernel).
# uname -a
Linux localhost.localdomain 4.1.12-94.3.9.el7uek.x86_64 #2 SMP Fri Jul 14 20:09:40 PDT 2017 x86_64 x86_64 x86_64 GNU/Linux
This behaviour can be changed with these commands:
First you have to get the linenumber of your new target kernel:
# grep ^menuentry /etc/grub2.cfg  | xargs printf '%s\n' |grep Oracle

Watch Oracle OpenWorld 2017 Keynotes On Demand

imageWatch Keynotes on YouTube using these links:

Larry Ellison (Sunday Oct 1st) –

Dave Donatelli (Tuesday Oct 3rd) – 

imageThomas Kurian (Tuesday Oct 3rd) – 

Larry Ellison (Tuesday Oct 3rd) – 

SuiteConnect – Evan Goldberg (Wednesday Oct 4th) – 

imageJavaOne Keynote (Monday Oct 2nd) –


The post Watch Oracle OpenWorld 2017 Keynotes On Demand appeared first on AMIS Oracle and Java Blog.

Oracle OpenWorld (JavaOne) 2017 : Day 4 (Thursday)

I met up with some folks for breakfast, which was a first for this week. From there I went to my room, finished off some blogs and cleared down some work emails, then I was ready to start the day.

OpenWorld finished the day before, but JavaOne continued into Thursday, and since I was registered for both I decided to check out some sessions. A quick look through the agenda showed every session for the (more...)

12c Parse

Following on from a comment to a recent posting of mine about “bad” SQL ending up in the shared pool and the specific detail that too much bad SQL could cause contention problems while staying virtually invisible, there’s a related note today on the ODC (formerly OTN) forum of a little change in 12.2 that alerts you to the problem.

Try executing the following anonymous block (on a non-production system):

declare m1 number;

Presentations from Oracle Open World

With Oracle Open World 2017 over the ICS presentation is available at – Oracle integration cloud service (ICS) best practices learned from the field (OOW17)

We saw a lot of exciting new features and capabilities coming from Oracle in the ICS space. So keep an eye on the site as we publish new articles.

The API Platform presentation that was co-presented with Luis Weir is here…

Oracle OpenWorld 2017 : Day 3 (Wednesday)

I’m finally starting to sync with the new time zone, so I had to set an alarm to be up in time for an 08:00 appointment.

First up was an Autonomous Data Warehouse Cloud Hands-On Lab in the Hilton with Yasin Baskan and Hermann Baer. I wrote a bit about this separately here.

After speaking to Chris Jones I was planning on going to the next lab. Unfortunately it was full, so sat at a (more...)

Autonomous Data Warehouse Cloud Hands-On Lab : My Thoughts

I signed up to a hands-on lab for the Autonomous Data Warehouse Cloud Service. These are the notes I took during the lab. They are a little scrappy, but I think you will get the idea…

I had some prior information due to the briefings I attended before OpenWorld, but everything I’ve mentioned here has been said publicly in OpenWorld sessions and is part of the hands-on lab.

Lab Outline

During the hands-on lab we (more...)

Where in the World is Goth Geek Girl, Week 41

So now that I’m finished just taking it easy, playing hooky from Oracle Open World and Oak Table World…uh, yeah….

I get to recover from emergency surgery for another week and while I’ve been busy writing slide content, building out new abstracts for the new year, along with content for a couple books, I’m finishing chapters on.  My ebook is about to come out for DevOps for (more...)

Oracle OpenWorld 2017 : Day 2 (Tuesday)

I started the day by catching up with the blog and answering some more questions about the Autonomous Database stuff. In most cases my answers were, let’s see what gets released. 🙂

Once I had caught up I made a very brief trip to the gym to do a bit of weights and some stretching, then I cleaned up and headed down to the conference.

I did a tour of the developer lounge and demo grounds (more...)

Driving for Change- Women of Oracle

Somehow I’ve made it a pastime of pointing out how many times women are passed up for recognition while men are promoted around them. Its not that the men were identified as better or worse than women, but just about how heavily we scrutinize and limit women while everyone else passes them by. Now I’m going to ask the Oracle folks to not take this personally, but hopefully (more...)


Here’s a quick quiz.

According to the Oracle 12.1 Database SQL Tuning Guide the first stage of parsing a statement is the Syntax Check, which is followed by the Semantic Check, followed by the Shared Pool Check. So where you do think the statement text will be while the Syntax Check is going on ?



Oracle 18c: self-driving, self-scaling, self-repairing AND documentation-free (?)

Yesterday Larry Ellison announced Oracle 18c:
After 12c now 18c?
Why 18 and not another number greater 12?
Inside a whitepaper released with the announcment the version 18c is not named at all.

The whitepaper just contains some high level information about the autonomous database:

and some licensing information:
But no real information about this new database 18c.
If this new database works like promised:
Fully automated patching, upgrades, backups, and availability architecture perform (more...)

Oracle DB 12.2 on Oracle Linux: Preinstallation tasks and Installation

If your decision was to use Oracle Linux as OS for your Oracle DB the preinstallation tasks are quite easy (an installation of Oracle Linux inside virtualbox is shown in this postings: virtualbox settings, linux installation, guest additions):

Just install the package oracle-database-server-12cR2-preinstall:
[root@localhost database]# yum install oracle-database-server-12cR2-preinstall
Geladene Plugins: ulninfo
Abhängigkeiten werden aufgelöst
--> Transaktionsprüfung wird ausgeführt
---> Paket oracle-database-server-12cR2-preinstall.x86_64 0:1.0-3.el7 markiert, um installiert zu werden
--> Abhängigkeit (more...)


How can a single piece of SQL text – checked very carefully – end up with multiple SQL_IDs ? There are probably quite a lot of people who know the answer to this question but won’t think of it until they’re reminded and, thanks to a question that came up on the forum formerly known as OTN a couple of days ago, I was reminded about it recently and rediscovered an article I had drafted (more...)

Imagine If You Will – The Oracle HCM Cloud Solution Library

Foreword:  When I was young, I tried like heck to develop a Rod Serling imitation.  I was a big fan of The Twilight Zone series, including the various revivals.  Alas, I was unable to get anywhere close and eventually gave it up.  But I admittedly still love the phrase "Imagine if you will".  So it's cool that I get to use it here.  See?  Work can be fun.

Imagine if you will the opportunity to (more...)

PL/SQL functions: Iterate and keys for associative arrays

Unfortunately associative arrays still require more “coding”:
we still can’t use “indices of” or “values of” in simple FOR(though they are available for FORALL for a long time), don’t have convinient iterators and even function to get all keys…
That’s why I want to show my templates for such things like iterator and keys function. You can adopt these functions and create them on schema level.

   type numbers  is table of number;
   type anumbers  (more...)

Running Oracle Linux inside VirtualBox: Installation Virtualbox guest additions

First you have to insert the Virtualbox Guest Additions iso-image:
You can check this here:
 If this does not work, just add the iso into the IDE controller of virtualbox:

 As root you have to mount the image:

Before you can run the installer you have to get the following packages:

yum list kernel*
Take the one with "devel" which version matches:
uname -a
Linux localhost.localdomain 4.1.12-94.3.9.el7uek.x86_64 (more...)