In the past, during OOW Oracle published the official dates of OOW of the following year, but in the last few years they stopped doing this, so we can’t be sure when OOW19 will be. There was a lot of unknown about OOW18 until the official dates were released (and 2018 is the first year the User Group Sunday was removed and it became a 4-day event)
This topic has been sitting in my backlog for a long time and I finally decided to write it. Analytic functions are not so new anymore (they’ve been around since Oracle 8i), but they are still a very powerful tool.
This is based on a real case I had quite a few years ago. A client came to me with a question regarding a graph they had to generate.
It all started when Franck Pachot tweeted a simple tweet. The tweet was of building number 600 at Oracle offices and Franck wrote: “Dedicated to all ORA-600 friends”. To that Connor McDonald replied with: “The 7445 building is in the middle of the lake. Don’t try go there :-)” which led me to start a thread of “if buildings behaved according to the meaning of their ORA- number”.
Oracle Open World 2018 has come to an end.
This was my 9th OOW (I’ve been attending OOW since 2010) and my second as a speaker, and it was awesome.
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.
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.
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.