Oracle SOA Suite 12c : Audit Levels (Off, Production, Development)

Inside the Enterprise Manager (URL: http://yourhost:7001/em) you can configure SOA Suite Audit Levels:

Choose "Common Properties"

Click on "Change Profile"
The oracle documentation shows the following:

  • Off:
    No business flow instance tracking and payload tracking information is collected. Drilling down into a flow shows the components and their status. Using this setting limits database growth, and also helps reduce latency and improve throughput.
  • Production:
    Flow and audit event information is collected and (more...)

ODC Latin America Tour : Barranquilla

When I woke up the first thing I had to do was figure out how I was going to do a cloud demo when I didn’t have WiFi at the venue. The building was really new and they hadn’t sorted out the networking yet. I re-purposed a Docker container running Oracle 18.3 and got some of my demos working, that were meant to be running on Oracle Cloud DBaaS or Autonomous Transaction Processing. I (more...)

ODC Latin America Tour : Quito to Barranquilla

There was about six of us all on the same flights from Quito to Barranquilla, so the original plan was to meet up at about 06:00 and head off for the airport, but our first flight was delayed, so we left the hotel at about 06:45. The traffic hadn’t started to pick up yet, so it only took about 30 minutes to get there.

Once checked in and through security it was just a case (more...)

Ya Gotta Water The Garden

With his love
And his carin'
He puts his life
Into beauty sharin'
And his children
Are his flowers
There to give us peace
In quiet hours

And I'll do anything I got to do
Cut my hair and shine my shoes
And keep on singin' the blues
If I can stay here in Johnny's garden

                         - From "Johnny's Garden" by Stephen Stills


VirtualBox 5.2.18

VirtualBox 5.2.18 was released yesterday.

The downloads and changelog are in the usual places.

I’ve installed this on my Windows 10 laptop and all seems OK. In fact, it seems to have made a difference to an annoying timeout I was seeing between some Docker containers running inside a VirtualBox VM. I’m not sure if this was just a fluke of the reinstall, or a real fix. Either way, it’s welcome. 🙂




ODC Latin America Tour : Quito

The first event of the Oracle Developer Community Latin America Tour (Northern Leg) was in Quito, Ecuador. A group of us met in the hotel lobby at about 07:30 and went across to the conference venue. The event began with an introduction by Paola Pullas and Marco Galarza. This was followed by Pablo Ciccarello with an introduction to the Oracle Developer Community, the Oracle ACE program and Oracle Developer Champion program.

It was a three (more...)

ODC Latin America Tour : Birmingham to Quito

The day started at 03:00, which is a silly time to start the day. I got a taxi to the airport and after a short queue for bag drop, I was waiting for the gate to open.

The first flight from Birmingham to Amsterdam went well and we arrived ahead of schedule. After about 90 minutes I was on the plane for the journey from Amsterdam to Quito. I could see there were some free (more...)

Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP)

A few days ago Oracle announced the general availability of the Autonomous Transaction Processing service on Oracle Cloud. This is the next member of the Autonomous Database family of products.

I’ve already written about provisioning the Autonomous Data Warehouse service and now I’ve used the Autonomous Transaction Processing service also.

I also wrote about loading (more...)

Another Taste of India– ODevCYatra 2018

July 2018 saw another edition of the Oracle Developers’ tour through India, called Yatra. In just over two weeks, seven cities participated in this tour – with each city hosting a one day mini-conference (three of four parallel tracks).


Organized by many volunteers from the local chapters of the All India Oracle User Group, coordinated by Sai Penumuru Janakiram – who did a really tremendous job – this was another great experience. The Oracle ACE (more...)

Which Oracle Release are you using?

Post Date: August 2018!

Recently an awesome Oracle Guru friend of mine questioned someone who was installing with the word “seriously”, which is think shows that Oracle staff sometimes don’t live in the same technological world as the rest of business.

My response was: is normal. In the real world:

– large corps mostly use old versions
– consultants look at current versions
– Oracle staff look (more...)

GraalVM – why a different VM?

If you read press around Java you’ll have come across references to GraalVM. So what is it and why would I use it?

There is an excellent podcast from Software Engineering Daily that digs into the subject and can be found here and here. But let draw out some of the reasons as to why GraalVM is interesting.

Whilst multiple languages on top of the JVM is nothing new, such as Scala , Kotlin, and (more...)

Extended Histograms – 2

Following on from the previous posting which raised the idea of faking a frequency histogram for a column group (extended stats), this is just a brief demonstration of how you can do this. It’s really only a minor variation of something I’ve published before, but it shows how you can use a query to generate a set of values for the histogram and it pulls in a detail about how Oracle generates and stores column (more...)

Oracle Cloud Total Cost of ownership Calculator – rather confusing

I was interested enough to try out the Oracle  TCO calculator that I was sent an email about. I can honestly say it has rather confused me in what it is comparing and how the results are calculated.

I will share a few screen shots and I will take you through my thoughts

I put a dummy company name in and my country – bizarrely it does not auto select the currency.

I then hit (more...)

Extended Histograms

Today’s little puzzle comes courtesy of the Oracle-L mailing list. A table has two columns (c2 and c3), which contain only the values ‘Y’ and ‘N’, with the following distribution:

select   c2, c3, count(*)
from     t1
group by c2, c3

C C   COUNT(*)
- - ----------
N Y       1994
Y N      71482

2 rows selected.

The puzzle is this – how do you get the optimizer to predicat a cardinality of (more...)

Where to find the oracle-database-ee-18c-1.0-1.x86_64.rpm package?

After writing about the release of Oracle database 18c i wanted to download
to try the rpm-based installation.
But this rpm is not included in
The oracle documentation shows:
 But on OTN and Delivery Cloud only the zipfile without the rpm can be downloaded...

So let's see, when the download pages are updated...

Achieve Data Democracy with effective Data Integration

For straight fourth year, I was pleased to be the part of AIOUG ODevCYatra as a speaker. This year, AIOUG re-branded the ages old OTNYathra as ODevCYatra to align its focus to the fatty developer community. The thought and execution remained the same though – 7 cities, 35 speakers, and a very tight schedule. I … Continue reading "Achieve Data Democracy with effective Data Integration"

All about headroom and mandatory patching before June 2019

This post was triggered upon rereading a blogpost by Mike Dietrich called databases need patched minimum april 2019. Mike’s blogpost makes it clear this is about databases that are connected using database links, and that:
– Newer databases do not need additional patching for this issue (,, 12.2 and newer).
– Recent PSU patches contain a fix for certain older versions (, 11.2. (more...)

Oracle Weblogic 12c: Extracting the complete configuration via python script

If you want to get all information out of a weblogic server via than you can use the following script:
# written by Dietrich Schroff 2018
import sys

sys.stdout = open(OutputFile,'w')

def loopOverAllSubdirectories(goIntoThisDirectory,depth):
    print depth," "*depth*2,goIntoThisDirectory
        allParameters=[ x for x in inputArray if (not ("dr--" in x) or ("drw-" in x)) ]

Translating Chinese to English in SQL with Microsoft Translator

In Oracle, I had a table of data which had some Chinese words that I needed to translate into English on the fly, in SQL…this is how I did that…

Microsoft have a translator facility here with the Translator Text API v3.0 to allow you to call it programmatically. I’m using Microsoft as I’m currently working on Azure – of course, there are other translation facilities available.

The API has a translate method which one (more...)

Could RedHat’s absolute commitment to OpenShift put them into difficult waters?

As a middleware (to use a fading term) or technical architect, I preferred not to get too involved in the detailed OS layer considerations when it can be helped (my Infrastructure Architect colleagues will always know more about NICs, port bonding, kernel versions etc etc than I ever will) and why I prefer to work with PaaS over IaaS.

But there is an undeniable trend where having a greater understanding of the OS is necessary, (more...)