Hello World! I’m extremely happy and excited to announce that, this week, I’ve just started a new Product Manager role at Oracle! I’m joining Roy Swonger, Mike Dietrich, Daniel Hansen and Bill Beauregard on the Oracle Database Migrations, Upgrades, Patching and Utilities PM team! After working more than 15 years on companies like IBM, Capgemini, …
Apr 30
New DBA_IMMUTABLE_TABLES view, starting on 19.11
If you follow my quarterly dissecting database patches series, you will note that on 19.11 (April-2021 CPU) oracle introduced a new USER/ALL/DBA_IMMUTABLE_TABLES view. This seems to be related with the new blockchain feature, but on 19.10 (the previous RU), oracle have already created USER/ALL/DBA_BLOCKCHAIN_TABLES. In this post I will investigate the differences among them. So, …
Apr 30
Dissecting 210420 BP, PSU, RU and RUR
I am quarterly writing a post dissecting the changes implemented by Oracle CPUs so we can understand better the modifications implemented by Oracle in our Databases. The following patches were analysed: 11.2.0.4 11.2.0.4.210420 DB PSU 11.2.0.4.210420 Exadata Bundle Patch 11.2.0.4.210420 OJVM PSU 12.1.0.2 12.1.0.2.210420 DB PSU 12.1.0.2.210420 Exadata Bundle Patch 12.1.0.2.210420 OJVM PSU 12.2.0.1 12.2.0.1.210420 …
Apr 30
Oracle April 2021 Critical Patch Advisory – PL/SQL detailed changes
Oracle April 2021 Critical Patch Advisory changed objects performed by each database patch. For more details and the catalog, check the main post: Dissecting 210420 BP, PSU, RU and RUR What exactly changed for each? (click to see detailed line changes) 12.1.0.2 SYS.DBA_LOGSTDBY_NOT_UNIQUE – VIEW 12cR1 (BP) SYS.DBA_LOGSTDBY_UNSUPPORTED – VIEW 12cR1 (BP) SYS.DBA_LOGSTDBY_UNSUPPORTED_TABLE – VIEW …
Apr 15
Protected: How to bypass Oracle Blockchain DROP restriction – Method 3
There is no excerpt because this is a protected post.





