Category: Oracle Database General

Oracle Database General

Apr 15

Protected: How to bypass Oracle Blockchain DROP restriction - Method 2

There is no excerpt because this is a protected post.

Apr 14

Protected: How to bypass Oracle Blockchain DROP restriction - Method 1

There is no excerpt because this is a protected post.

Feb 10

Oracle January 2021 Critical Patch Advisory - PL/SQL detailed changes

Oracle January 2021 Critical Patch Advisory changed objects performed by each database patch. For more details and the catalog, check the main post: Dissecting 210119 BP, PSU, RU and RUR What exactly changed for each? (click to see detailed line changes) 12.1.0.2 SYS.DBMS_AWR_REPORT_LAYOUT - PACKAGE BODY 12cR1 (BP) SYS.DBMS_SQLPATCH - PACKAGE BODY 12cR1 (BP) SYS.DBMS_SQLPATCH …

Continue reading

Feb 10

Dissecting 210119 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.210119 DB PSU 12.1.0.2 12.1.0.2.210119 DB PSU 12.1.0.2.210119 Exadata Bundle Patch 12.1.0.2.210119 OJVM PSU 12.2.0.1 12.2.0.1.210119 RU 12.2.0.1.210119 OJVM PSU 18 18.13.0 RU …

Continue reading

Jan 24

No more 12.2 Oracle RURs patches after 2021?

As some of you know, every quarter, once Oracle releases it's Critical Patch Update Advisory, some of us (like myself, Mike Dietrish, Frits Hoogland and some other DBAs around) download some or all the available patches to scan the differences Oracle performed in the database. In my case, I download all the PSUs, BPs, RUs, …

Continue reading