John Watson's blog

Now available!
https://docs.oracle.com/en/database/oracle/oracle-database/20/books.html

Going through the New Features guide, there is a shed load of wonderful enhancements. Then you look at the Licensing guide, and most of them require Exadata or Oracle Cloud or both.

Many times I've seen the question on forums "How can I move a table from one schema to another?" and the answer is always that you can't. You have to copy it. Or export/import it. Well, here's a way. It assumes that you are on release 12.x and have the partitioning option.

Oracle corporation will (as of 24 September 2019) support customers running on VMware.

A very nice licensing change in 19c: you can now have up to three PDBs in a Standard Edition Multitenant database.

Do you know about multiple domain certificates? If not you may have to learn quickly, because Oracle has changed the way they are handled in release 12.2. This is going to break a lot of applications.

Will upgrade from 12.1 to 12.2 break your applications? It may if your developers are using JSON.

I am fascinated by what I call "equal SQL": statements that are equivalent, in that they deliver the same result but may have hugely different performance characteristics. Here's a little case study.

Just how effective is Hybrid Columnar Compression? This test shows that HCC is impressive, but that thought needs to be put into choice of compression algorithm.

Comparing database 12cR1 release 12.1.0.2 to 12cR2 release 12.2.0.0.3, I see these new parameters:

Move a table without locks and without breaking indexes. That's pretty cool.