Category: Oracle Database General

Oracle Database General

Aug 27

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

Aug 27

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

Aug 25

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

Jul 14

OCI Volumes - What happens to Incremental backup when Full is deleted?

Those days, in one of my company mail threads, a colleague stated: "We have tested the restores, when the oldest backup is an incremental and prior full backups have been deleted. It works!" This is a pretty funny scenario. So I've decided to do some further investigations to understand what really happens in the background: …

Continue reading

Apr 17

Dissecting 200414 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 analyzed: 11.2.0.4 11.2.0.4.200414 DB PSU 11.2.0.4.200414 Exadata Bundle Patch 11.2.0.4.200414 OJVM PSU 12.1.0.2 12.1.0.2.200414 DB PSU 12.1.0.2.200414 Exadata Bundle Patch 12.1.0.2.200414 OJVM PSU 12.2.0.1 12.2.0.1.200414 …

Continue reading