(Martien van den Akker) My current customer has a SOA Suite implementation dating from the 10g era. They use many queues (JMS serves by AQ) to decouple services, which is in essence a good idea.

(amitzil) Here is an interesting optimizer case where updated statistics and histograms cannot solve the performance problem. This might be an uncommon case, but it happened for one of my clients and this post is the result of some research on this.

(Gerald) The new version of the free Oracle Database edition, Oracle Database 18c Express Edition, just got released for Linux 64-bit.

(Bobby Durrett) Recently during testing a merge statement was running forever in our qat environment after a simple change. We had simply added a few columns to an existing table.

(Peter Raganitsch) Usually the APEX images reside in a directory on your server called /i/, which can be changed on instance or application level.

(Alexander Anokhin) Those who are on Exadata and change _SERIAL_DIRECT_READ on session or system level may be interested in the issue described below. The issue exists in all versions from 11g and above.

(stewashton) When I write SQL there is a bit of trial and error (laughter), so I need as complete a set of test cases as possible. Here’s what I came up with.

(Frits Hoogland) I was asked some time ago what the Oracle database event ‘TCP socket (KGAS)’ means. This blogpost is a deep dive into what this event times in Oracle database 12.1.0.2.180717.

(Hemant K Chitale) Oracle 11g supports specifying a Virtual Column as the Partition Key.

(Robert Crames) I wanted to know which “ORA-” Errors have occured in my Production-DB and issued a