(Uwe M. Küchler) Sometimes it’s hard to find what you’re looking for in the Oracle documentation or on MOS if you don’t already know what exactly to search for. This happened to me while trying to find out how the method of changing the DB connection for the EM repository changed in 13c. So I thoug

(Kellyn Pot’Vin-Gorman) One of the Iceland 2017 SQL Saturday sessions got me thinking about indexing and how similar and different it all is in Oracle vs. SQL Server.

(amitzil) I wrote before about optimizer changes after upgrades, so this is a quick post about some more information related to this topic.

(Martin Bach) Thanks to the prep-work done by Andy Colvin, who continuously and boldly goes where no man has gone before, one of our Exadata systems in the lab is now fully upgraded to 12.2.0.1. It comes fully equipped with the matching cellos to support all the cool new features. Exciting times!

(Dermot O’Neill) Oracle Database 12c allows you to define a column to be an IDENTITY column.

(Richard Foote) I previously discussed just how easy it is to convert online a non-partitioned table to be partitioned with Oracle Database 12.2.

(Kim Berg Hansen) A new little feature in Oracle Database 12.2 is, that you can convert strings to dates without worrying about exception handling. (That goes also for converting to numbers or timestamps or other datatypes, but here I’ll concentrate on dates.)

(Frits Hoogland) Actually, this is a follow up post from my performance deep dive into tablespace encryption. After having investigated how tablespace encryption works, this blogpost is looking at the other encryption option, column encryption.

(Vyacheslav Rasskazov) There are multiple optimizer features introduced in the Oracle Database 12.2 Release. Bushy Join Trees is the one that I’ll be demonstrating in this post.

(John Hallas) If a Goldengate replicat process fails then occasionally on the restart it skips the correct RBA and ‘loses it’s position’. The relative byte address (RBA) is the location within the trail file to indicate the current transaction.