Why I Don’t Like ANSI Joins

Since Oracle started supporting ANSI joins in 9i, the Oracle community was divided into two groups: one loved it and tried to convince everyone to use it, and the other hated it and has never switched. As you probably understand from the title, I’m in the second group, and this is why.

Continue reading “Why I Don’t Like ANSI Joins”

DB Console vs. EM Express

I usually don’t work with the local version of EM. I haven’t used DB Console in 11g and below so much, and I used EM Express in 12c even less. But when a colleague contacted me not too long ago and said that Oracle stripped down a lot of functionality in EM Express, I had to check it out.

Continue reading “DB Console vs. EM Express”

Did You Know #28 – Standby + RAC

data_centerIn an Oracle Data Guard configuration, the primary and standby databases can have different configurations. It’s very common to have a smaller server for the standby database (less CPUs, less memory, etc.) and it’s quite trivial to configure. But what about RAC?

Continue reading “Did You Know #28 – Standby + RAC”

Oracle 19c – Features We Know About

Oracle Open World was interesting like every year. This year, Oracle started talking about features that will probably be in Oracle 19c (which is the last 12.2 release). The rumor says that it will be out in the first half of 2019 (somewhere around April-May).

As you might know, I didn’t attend a lot of sessions, but managed to gather some information about expected features (given Oracle’s safe harbor of course).

Continue reading “Oracle 19c – Features We Know About”