I wrote before about optimizer changes after upgrades, so this is a quick post with some more information related to this topic.
I wrote before about optimizer changes after upgrades, so this is a quick post with some more information related to this topic.
When I open Oracle documentation to look for something, people usually raise their eyebrows (almost as they do when I open sqlplus). Most of them simply say: “What do you
I ran into this post on Linkedin talking about what non-Israeli people should expect when working with Israelis (and especially if they visit Israel for business). It’s a very nice
In the previous part (you can find it here) I discussed the character sets Oracle supports and the length limits. In this part I’ll show how it is actually stored and
Remember my post about Oracle 12.2 release date? I’ve heard rumors that Oracle changed the date to March 1st, and it was right! Oracle 12.2 is available for download for
A few days ago I was browsing the documentation and suddenly realized that I haven’t gone over the 12.2 books. One of the things I like to do is reading
Oracle 12.2 is going to be a very interesting one with lots of great features. I published a few blog posts about some of the features, you can read about
When writing a query with order by, we can use the column position instead of its name. This order by”trick” is easy to use, but should be handled carefully as
The internet is full of information about indexes, and for a reason. Indexes in a database is probably the most important performance related topic. There are so many cases, properties,
Many people are using DBMS_STATS to gather optimizer statistics. This package has many different options, and I wanted to tell you about one option for disabling automatic statistics gathering. When we