Crazy Idea of Mixing Flashback Data Archive and Editioning


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

Continue reading

Advertisements

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