Dissecting 201020 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.201020 DB PSU 11.2.0.4.201020 Exadata Bundle Patch 11.2.0.4.201020 OJVM PSU 12.1.0.2 12.1.0.2.201020 DB PSU 12.1.0.2.201020 Exadata Bundle Patch 12.1.0.2.201020 OJVM PSU 12.2.0.1 12.2.0.1.201020 …

Continue lendo

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 lendo

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 lendo

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 lendo

LAOUC 2020 - Deep dive into Oracle Cloud metadata

Ontem, dia 24 de August 2020, apresentei uma sessão no LAOUC sobre metadados de OCI! Abstract: Com mais empresas migrando seus ambientes para o Oracle Cloud, obter acesso a seus metadados é uma tarefa crítica para controlar seu próprio ambiente. Nesta sessão, obtenha uma compreensão abrangente de como você pode “extrair” totalmente essas informações do …

Continue lendo