When Even Histograms Can’t Help

Here is an interesting optimizer case where updated statistics and histograms cannot solve the performance problem. This might be an uncommon case, but it happened for one of my clients and this post is the result of some research on this.

Continue reading “When Even Histograms Can’t Help”

DST Patch in Active Standby Environment

Different software components (operating systems, databases, etc.) are updating our clocks automatically when our country changes the clock (when daylight saving starts or ends). In order to do that, the system has to know the date for the daylight saving. This is the DST information.

Continue reading “DST Patch in Active Standby Environment”

New Look

I’ve been think about it for a long time, I don’t really like the look of the blog. I wanted to change it a while ago, and checked different options, but never actually got to do it.

Yesterday I finally decided to do it!

I hope you’ll like the new look, maybe I’ll add some more stuff in the future. Let me know if you have any comments or suggestions.

Cheers

ODC Appreciation Day – Image-Based Installation

As every year since 2016, we’re having the ODC Appreciation Day around October. If you don’t know what “ODC Appreciation Day” is, it is Tim Hall’s initiative to simply say thank you. It started as “OTN (Oracle Technology Network) appreciation day” and then changed to “ODC (Oracle Developer Community) Appreciation Day” when Oracle rebranded OTN. It is meant to acknowledge that we, as a community, appreciate what the people at Oracle community are doing for us by writing these posts and add the hashtag #ThanksODC.

Continue reading “ODC Appreciation Day – Image-Based Installation”