(Martien van den Akker) Once in a while you need to validate a service that has dates in the response. Although SoapUI has xpath and xquery match assertions, validate against strings is quite difficult. How to do a date comparison against for instance the current date?

(John Brady) In my previous post on costing a Hash Join overflow to disk I came up with a formula for the cost of a Hash Join operation that overflows to disk based on tests I had done, but I also mentioned that there might be other factors involved not yet exposed by my testing.

(connormcdonald) Kris Rice made mention on Twitter about the free (but limited lifetime) IP address to Country mappings that you can get from Maxmind.

(David Fitzjarrell) Oracle 12.2.0.1 offers a number of enhancements over version 12.1.0.2, but one of those enhancements may throw a ‘monkey wrench’ into any alert log monitoring that may be in effect.

(David Fitzjarrell) Every once in a while someone decides that Oracle functionality isn’t fast enough and makes a valiant attempt to correct these perceived deficiencies.

(Bobby Curtis) As of August 2017, Oracle has released two distinct architectures for Oracle GoldenGate. The newest of which is the Microservices architecture. These question has to be asked, how can both of these architectures work together?

(Martien van den Akker) In 2016 I did several posts on automatic installs of Fusion MiddleWare, including domain creation using wlst.

(Zahid Anwar) Exadata Write-Back Flash Cache provides the ability to cache not only read I/Os but write I/O to the Exadata’s PCI flash on the storage cells.

(Mohamed Azar) I am trying to restore the database to new host, While doing the first step, I try to start the database,

(Rob van Wijk) Last Friday at work, I overheard a conversation between two DBA’s about a performance problem of a job which usually ran in 10 minutes, now taking more than 4 hours. I helped them pinpoint the problem: a simple SQL query which took >95% of the time.