Simple demo of message propagation

If you’re using AQ, then it’s simple to setup simple enqueue and dequeue facilities on your local database to provide all sorts of asynchronous style processing in your applications.  As long as you’re applications are designed and built to handle it, the “fire and forget” model to keep user applications responsive, and all of the “heavy lifting” done in the background is a very attractive one.

You can also use AQ to achieve the (more...)

UKOUG Tech16: “Oracle Forms: out of the browser, into the cloud!”

So, Oracle Forms is still alive and kicking and this while browsers are desupporting plugins.
In Oracle Forms 12c it's possible to run an application out of the browser.

Want to see how?  Come to our session: "Oracle Forms: Out of the browser, into the cloud".

We will show you what the possibilities are and how to configure this.

Video&Slides: Version Control for PL/SQL

Last week we hosted a webinar about how PL/SQL developers can manage their PL/SQL code bases with Gitora, the version control tool for PL/SQL. Many thanks to everyone who attended. You can watch the recording of the webinar and view the slides below.

The webinar consist of two parts:

1) Version Control Strategies for PL/SQL
2) Live Demo of Gitora



Running Watches and Starting Line Rituals in the Wild

Just back from completing my 3rd Florence Marathon (Firenze Marathon or Maratona di Firenze if you prefer). A great run around a fantastic city. I really enjoyed it and my finish time wasn’t too bad for my little legs.

While in Florence I noticed some great, localized Asics billboards for the event and they reminded me of how personal technology drives the adoption of what might seem to be “curious rituals” of behaviour, be it (more...)

SSO to cloud control 13c with Azure active directory

So more on this cloud stuff then.....

Well in this case the work is just as applicable to a normal on premises configuration with 'standard' Active directory (other types of ldap directory can be used but i guess AD is the most widespread).

In this particular case (a follow up to my post on configuring HA for cloud control in Azure) i now want to enable single sign on to this cloud control using (more...)

Answer with SQL: How many weekdays a year?

I'm a big fan of generating data with dual, using a perk of the connect by syntax.

I think Tom Kyte was the originator of this technique. It's not necessarily the fastest method, but it's super convenient - no table required.

Today I wanted to know how many weekdays a year, so I defined 365 rows on the fly using sysdate to turn these into each day of the year. Then I ran a simple (more...)

Tablespaces verkleinern (TEMP, USER_TS, ORA-03297)

Die Select-Statements in diesem Blogpost habe ich von anderen Webseiten kopiert. Daher ist dieser Beitrag eher als Zusammenfassung unterschiedlicher Lösungsversuche zu sehen und dient mir als schnelle Hilfe bei der Verkleinerung eines zu großen Tablespaces. Schaut euch die Quellen an, die sehr viel detaillierter auf die jeweiligen Probleme eingehen.

Wer kennt nicht die Situation? Der DBA ruft an und meint der TEMP Tablespace verbraucht mehrere hundert Gigabyte an Speicher.

Was ist in solch einer (more...)

Red Samurai – Oracle Cloud Customer (DBaaS, JCS, DevCS)

We understand importance of Cloud services and decided to move out internal development infrastructure (ADF and JET) into Oracle Cloud. From today we are Oracle Cloud customers and users for the following services:

1. Oracle Database Cloud Service

2. Oracle Java Cloud Service

3. Oracle Developer Cloud Service

Exciting times ahead. Expect more interesting topics about Oracle Cloud and ADF/JET.

11 Tips to Improve Focus and Concentration at Work

Do you often find yourself not focusing at work? Or, you try to focus, but something else comes along and distracts you? I know how this feels. I’ve listed eleven ways to remove distractions and increase focus in this article. I’ve been able to improve my focus by removing some of the distractions I have […]

A Guide to the Oracle DROP TABLE Statement to Delete Tables in SQL

How can you delete a table in SQL? Learn how to do this by using the DROP TABLE statement in this article. How Can I Delete a Table in Oracle SQL? To delete a table in Oracle SQL (or any SQL for that matter), you run a statement called DROP TABLE. It’s called DROP because […]

Trip to Black (W)holes


Last week my kids’ school went on a field trip to the University of Santa Cruz to observe a black hole multimedia exhibition. We were invited there by Enrico Ramirez-Ruiz, the astrophysicist and the fellow parent at the school. When Enrico is not busy pushing the frontiers of science (he is impartial to violent explosions), he teaches astrophysics to children age 4 to 12.

The exhibition combined the visualized data from recent Extreme Mass (more...)

My Sangam 16 presentation: Policy Based Cluster Management In Oracle 12c

RSS content

Thanks to all those who attended my session on “Policy Based Cluster Management In Oracle 12c” during Sangam16. I have uploaded my presentation here.

Your comments and feedback are always welcome.


Exadata migration

Had a wonderful Sangam16 conference in India, and received much applaud for the two presentations delivered,  Oracle 12c multitenancy and Exadata migration best practices.

After a very short trip to India, life started to be business as usual again, and become busy. Was fully occupied with multiple assignments: Oracle EBS database health check assessment at a client for 2 days, GI/RDBMS/PSU deployments on Oracle Sun Super Cluster M7, Exadata configuration preparation and 9 databases migration (more...)

Another Thanksgiving Email

Here is another email we got Wednesday from a Dodeca Excel Add-In for Essbase customer.  This customer has a lot of VBA macros running some automation with Essbase and asked for some assistance.  We told it was as easy as replacing they Essbase function declarations file with our Dodeca Add-In  function declarations file, and then setting the variables that contain the location for the Dodeca-Essbase server.  In other words, replace this file:

With this file:

ADF New Feature – Masonry Layout Custom Size Dashboard

ADF and respectively comes with improvement for Masonry Layout component. Now we can define custom sizes for tiles - 9.4.1 How to Use a masonryLayout Component. This helps to define larger tiles and organize dashboard layout in more accurate way.

I have uploaded working demo app on GitHub, you can download it directly from repository or browse through the code - ADFAltaApp. I will be (more...)

Online Redo Log Switching from RMAN Backup

I was troubleshooting backup from standby databases and encountered an oddity which I wanted to verify.

Backing Up Archived Redo Logs with RMAN

Before beginning the backup, RMAN switches out of the current redo log group, and archives all online redo logs that have not yet been archived, up to and including the redo log group that was current when BACKUP command with any of the following clauses:


23 is the new 42

A bizarre one this week....

We upgraded one of our criticial production apps from to (+ latest PSU) and everything went well during the upgrade and seemingly afterwards too, that was until we had reports from the business that some data transfers from another system into this one were often being delayed.

After a bit of investigation we found the data was being pulled over by a (more...)

Just one more week


I’m off to UKOUG again this year.  It’s an awesome conference, and I’ll be doing three talks there.

On Monday at 3:30 it’s my first keynote talk Smile  “12 Things You’ll Love About the Oracle Database 12.2”, followed up at 6pm by “AskTom – One Year On”.

On Tuesday, at 3:30 I’ll be doing a talk for anyone want to come up to speed on all of the partitioning features with “Partitioning 101”.


Virtual Development Server: Install Jenkins for Continuos Integration / Delivery / Deployment


For automation of all of my processes I need Jenkins in my development server.

First I had installed Jenkins as Docker container via Vagrant Docker provider. But with this architecture it was very complicated to create docker images and run Docker containers on the Docker host, in this case my Vagrant Virtualbox.

So for simplification I have decided to install Jenkins with the provisioning of the Vagrant Virtualbox via a shell provider in my Vagrantfile:


Little things worth knowing: Can I Smart Scan a Global Temporary Table?

A question that has come up while preparing to deliver another Exadata Optimisation Class is whether you can offload queries against Global Temporary Tables (GTT) or not. There are subtle differences between heap tables and GTTs such as how statistics are handled and where they are stored that merit a little investigation.

I have used the lab environment on the X3-2 (Exadata, RDBMS) to test (more...)