Crazy Idea of Mixing Flashback Data Archive and Editioning

Now that Flashback Data Archive is now included in the base license, I had the crazy idea to mix it with Database Editioning.

Continue reading


Reasons for Using Jumbo Frames in RAC Interconnect

We are in the process of re-introducing Oracle RAC back into the organisation. I am having difficulty explaining the reasons for using Jumbo frames over the interconnect.

Continue reading

Examination of Neil Chandler’s Post about Adding NOT NULL Columns with DEFAULT values

Neil Chandler has a very interesting post about Adding NOT NULL Columns with DEFAULT values which:

From Oracle 11G, if you: ALTER TABLE table ADD ( column col-type DEFAULT def NOT NULL ) the default isn’t actually added to the data. It’s only added to the meta-data.

Continue reading