Small fix for SQLcl Java problem with Oracle 12.1
Let’s say you want to quickly use some cool features of SQLcl inside the script running on the database server, but only Oracle below version 12.2 is available there (which is the first one being shipped with SQLcl). This means that you have to download…
Constants vs. Parameterless Functions
Do you use parameterless PL/SQL functions in your queries? Did you know that this may cause performance issues? In this blog post I explain why parameterless functions can be the reason for bad execution plans in any Oracle Database. I recently had to analyze this…
Conference Review 2019 (Part 3)
In the last four weeks, I had the chance to speak at three different conferences. This was the finish of an intensive conference year for me with many impressions, learning, knowledge sharing, new and old contacts and of course a lot of fun. I am…
Integrate SQL*Plus Scripts in SQL Developer
I envy my DBA colleagues when they work with the Oracle Database from the command line in an incredibly efficient way. They just call a series of scripts with some parameters to get the desired information. Everything looks so easy, so smooth, so natural. I’m…
Partition Pruning and NLS Settings
NLS (National Language Support) parameters are very useful for multilingual applications in an Oracle database. But it is important to understand their impact on query performance. I was aware that NLS is important for indexes, but never thought about its impact on partitioning. In a…
Exadata Cloud at Customer: Real-life experiences
Today again very short post, just pointing to my recent article inside new issue of UKOUG magazine called #PTK (former Oracle Scene): Exadata Cloud at Customer: Real-life experiences. Enjoy! Advertisements
Conference Review 2019 (Part 2)
September was my second round of conferences this year. A presented my session “Avoid Horror Queries: Keep Your SQL Simple and Fast” on three different conferences, two of them organized by Trivadis. POUG 2019 Conference, Wroclaw/Poland For the second time, I joined the POUG conference in Poland….
Oracle ACE Associate
Today short post, just to announce that I became Oracle ACE Associate! I’m happy to be recognised by the Community and would like to thank all the people I’ve met during my career, who positively influenced me (not only with technical and Oracle knowledge!) and…
ExaCC: what to do if dbaas_diag_tool.pl fails
When you open Service Request related to problems on your Exadata Cloud at Customer (or other Oracle Cloud environments), very often you’ll be asked to upload diagnostic data, which can be easily gathered by running /var/opt/oracle/misc/dbaas_diag_tool.pl. If it works… In my case it failed, with…
How to Save 7 Keystrokes with dbms_xplan
An almost unknown simplification in the usage of dbms_xplan is possible since Oracle 12.2. Sometimes, there are small details that makes our job (a little bit) easier. In one of his presentations at the Kscope19 conference, Kim Berg Hansen mentioned an interesting detail about the syntax…