Performance Tips: Function Calls in WHERE Conditions
This post was originally published on this siteA typical reason of many performance issues with SQL are function calls in the WHERE condition. They make it difficult for the query optimizer to determine the cardinality. Fortunately, there are several ways to solve this problem. Function calls…
Last Week in Stream Data Integration & Stream Analytics – 16.02.2022
This post was originally published on this siteThis is the 239th edition of my blog series blog series around Stream Data Integration and Stream Analytics! As usual, find below the new blog articles, presentations, videos and software releases from last week. Happy reading and stay…
Half a Thousand Quizzes
This post was originally published on this sitePassed a minor milestone 😁 Sign in to https://devgym.oracle.com/ Go to Quizzes Go to Explore All Quizzes Scroll down to Author filters Put a checkmark at Kim Berg Hansen Result: (In fact, as you read this, the number will…
Creating a SQL Patch with Many Hints Requires a Hack
This post was originally published on this siteIn the past, when I created a SQL patch, I always specified a small number of hints. Last week, for the first time, I created one with more than 100 of them. Given their number, I didn’t want…
Last Week in Stream Data Integration & Stream Analytics – 31.01.2022
This post was originally published on this siteThis is the 238th edition of my blog series blog series around Stream Data Integration and Stream Analytics! This time (once again) the title Last Month in ….. would be more accurate As usual, find below the new…
Capture, save and open a tcpdump with Wireshark over ssh
This post was originally published on this siteDo you need live access to the network capture, but Wireshark is not installed on the system? Here a short guide how to capture, save and open a tcpdump with Wireshark directly over ssh.
Finding Wrong Hints
This post was originally published on this siteIntroduction I use the Oracle Database since many years. And I use hints. For experiments, but also in production code. There are cases when you know more than the Oracle Database. For example about the cardinality of a…
2021: Another Year at Home
This post was originally published on this siteI never wrote so few blog posts like in 2021. There are several reasons for this. But there are also good news: I was able to attend at least a few conferences this year. As you can see…
GraalVM Native Image – First Impressions
This post was originally published on this siteIntroduction A native image is an operating system specific executable file. You can build such an image for basically every application running on a Java virtual machine. This approach promises faster start-up times and lower resource consumptions. This…