John Watson's blog
Submitted by John Watson on Tue, 2019-11-26 11:11
Oracle corporation will (as of 24 September 2019) support customers running on VMware.
Submitted by John Watson on Mon, 2019-11-04 10:20
A very nice licensing change in 19c: you can now have up to three PDBs in a Standard Edition Multitenant database.
Submitted by John Watson on Tue, 2018-01-23 11:11
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.
Submitted by John Watson on Fri, 2018-01-05 12:52
Will upgrade from 12.1 to 12.2 break your applications? It may if your developers are using JSON.
Submitted by John Watson on Fri, 2017-03-31 05:01
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.
Submitted by John Watson on Tue, 2016-11-01 17:57
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.
Submitted by John Watson on Fri, 2016-10-21 14:54
Comparing database 12cR1 release 12.1.0.2 to 12cR2 release 12.2.0.0.3, I see these new parameters:
Submitted by John Watson on Wed, 2016-10-19 08:10
Move a table without locks and without breaking indexes. That's pretty cool.
Submitted by John Watson on Fri, 2016-10-14 07:54
Developers who come to Oracle with a background in procedural languages sometimes do not understand how efficient SQL's set oriented processing can be. This little demonstration should convince them: never use PL/SQL when SQL will do.
Submitted by John Watson on Sun, 2016-10-02 02:57
We all know that using SELECT * is bad programming. One reason is that you cannot control the order in which columns are returned. Well, you can in release 12c.
Pages
|