August 2020 archive

DBMS_PDB arriving on 11.2.0.4!

If you follow my CPU cycle dissect articles, you will note that a new package appeared on 11.2.0.4 on the EXA Bundle Patch (still not available with the PSU). DBMS_PDB! Until today, the only way to upgrade 11g to any 12+ PDB using the "plug way" would be following this approach: Of course there are …

Continue reading

Oracle July 2020 Critical Patch Advisory - PL/SQL detailed changes

Oracle July 2020 Critical Patch Advisory changed objects performed by each database patch. For more details and the catalog, check the main post: Dissecting 200714 BP, PSU, RU and RUR What exactly changed for each? (click to see detailed line changes) 11.2.0.4 SYS.DBMS_RCVMAN - PACKAGE BODY 11g (BP) SYS.DBMS_RCVMAN - PACKAGE BODY 11g (PSU) 12.1.0.2 …

Continue reading

Dissecting 200714 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.200714 DB PSU 11.2.0.4.200714 Exadata Bundle Patch 11.2.0.4.200714 OJVM PSU 12.1.0.2 12.1.0.2.200714 DB PSU 12.1.0.2.200714 Exadata Bundle Patch 12.1.0.2.200714 OJVM PSU 12.2.0.1 12.2.0.1.200717 …

Continue reading

ORACHKSUM v20.03 is out!

Today I'm releasing v20.03 of ORACHKSUM! Now the tool was updated with latest MOAT369 API and also received all the July-2020 CPU cycle dictionary updates. For the ones who don't know what I'm talking about, orachksum is a tool that scans your database for malicious internal code changes (like tampering your DBMS_OUTPUT PL/SQL code), comparing …

Continue reading

LAOUC 2020 - Deep dive into Oracle Cloud metadata

Yesterday, 24th August 2020, I gave a session to LAOUC about OCI metadata! Abstract: With more companies moving their environments to the Oracle Cloud, gaining access to its metadata is a critical task to keep track of your own environment. In this session, get a comprehensive understanding how you can fully “pull out” this information …

Continue reading