(David Fitzjarrell) Query tuning is a combination of art, science and intuition. Elegant tuning solutions are art, based on science, that science using two of Oracle’s events, 10046 and 10053. Which one is more beneficial depends on the query and the ‘bad’ execution plan.

(Uwe Hesse) Exasol uses a clustered shared-nothing architecture with many sophisticated internal mechanisms to deliver outstanding performance without requiring much administration.

(Dimitri Gielis) While running our final tests of APEX Office Print (AOP) 18.1 we hit “ORA-20000: Issue calling Main AOP Service (REST call: ): ORA-20001: You have exceeded the maximum number of web service requests per workspace.”

(Jagruti Jasleniya) Lockdown Profiles: Its a mechanism given by Oracle to restrict PDBs from doing certain operations or from restricting them from using certain Functionalities.

(Martien van den Akker) About a year ago, at my previous customer, a co-worker and I encountered and described a persistence problem with setting the Global Tokens in SOA Suite.

(Luc Bors) Recently I had to setup an application that was able to read twitter and, based on some predefined keywords, had to reply to specific tweets. I decided to have a look at node-red to set this stuff up

(Scott Wesley) Many, many moons ago, I created an error handling function for Oracle APEX, just like the original sample provided by Patrick Wolf for the 4.1 error handling feature. You’ll probably find a strong correlation between the two events.

(Zahid Anwar) I discovered an Oracle Cloud Database Backup failing with:

(Anuradha Mudgal) Let’s have look on the steps used for Cold Backup and Recovery From Archivelog.

(Hemant K Chitale) List Partitioning allows you to specify a value (or a set of values) for the Partition Key to map to each Partition.