The Evolution of the Oracle Documentation
When was the last time you looked into the Oracle documentation? If you rarely or never do so because you think you know the Oracle database, take another look at docs.oracle.com and browse in the online documentation. It’s worth it! A few weeks ago, I…
Oracle 19c: Auto-List Partitioning HIGH_VALUE Bugs fixed
New features are one reason to upgrade to a new Oracle release, bug fixes of known bugs are another one. With Oracle 19c, at least two bugs related to Automatic List Partitioning were fixed. I did some tests with Auto-List Partitioning on an Oracle 19.3…
Bitmap-based COUNT(DISTINCT) Functions in Oracle 19c
Oracle 19c provides a set of new SQL functions for bitmap operations. They allow fast computation of COUNT(DISTINCT) expressions. What is the purpose of these functions? The Oracle documentation is very sparse, but at least it tells us that the main focus are Materialized Views on…
MemOptimized RowStore in Oracle Database 19c
Since February, 13 2019 Oracle Database 19c is available. I blogged about this feature here and here. Time for an update. So, what’s new in 19c regarding the MemOptimized Rowstore? Fast Lookup Works with JDBC Thin Driver I listed 16 prerequisites for the MemOptimized Rowstore in this…