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…
Conference Review 2019 (Part 1)
In the last two months, I had the pleasure to speak at four different conferences. Each of them was unique in its own way, and all of them were definitely worth to attend. Of course, it is not possible to write down all impressions in…
Running utPLSQL Tests in SQL Developer
Introduction In November 2017 Jacek Gebal asked me if I could help to integrate utPLSQL into SQL Developer. In January 2018 we released the first MVP. Tests were executed in a new SQL Developer worksheet showing the result in the script output pane.This was easy…
Oracle Privilege Analysis in action
As Oracle has quite recently announced that Privilege Analysis is now included with the Oracle Database Enterprise Edition licence, I played a little bit with this cool feature to solve infamous ORA-01031: Insufficient privileges error. You can read results of my investigation in the article…
Bitmap-based COUNT(DISTINCT) Functions in Oracle 19c
Oracle 19c provides a set of new SQL functions for bitmap operations. They allow fast computation of COUNT(DISTINCT) expressions. What is the purpose of these functions? The Oracle documentation is very sparse, but at least it tells us that the main focus are Materialized Views on…
Social Media @trivadis