Online Statistics Gathering for ETL – Part 3
Preparing my session on Online Statistics Gathering for ETL for the DOAG conference, I noticed some points that I didn’t covered in the previous two blog posts. The first point is showing the problem that may arise if indexes are involved. The second one is…
Oracle Database Backup Service – Encrypt your 12.2 Database Backups to the Cloud
The Oracle RMAN backup encryption is necessary if you want to backup your database into the Oracle cloud. In Oracle 12c, you have three methods available to encrypt an Oracle RMAN backup: with a passphrase with a master encryption key hybrid with a passphrase and…
Online Statistics Gathering for ETL – Part 2
In the first part we looked at general preconditions for online statistics gathering to work and some restrictions. In this part we’ll take a look at what happens with direct path loads into partitioned tables. Partitioning There are also some points to consider while working…
Online Statistics Gathering for ETL – Part 1
Online Statistics Gathering has been introduced in 12c and is a very handy feature for ETL and batch jobs developers. However the devil is in the detail. There are some points to remember. Let’s take a closer look. Introduction If you are not familiar with…
DATABASE PATCH SET UPDATE 12.1.0.2.170117 apply fails – catconInit failed, exiting
Last weekend was patchday. The goal was to apply the patch 24732082 (DATABASE PATCH SET UPDATE 12.1.0.2.170117) to a 12.1.0.2 database on AIX. The OPatch precheck returned no error and OPatch apply was ok. The problem was the post step, the datapatch command failed with…
Oracle Data Pump with the 12.2.0.1.0 Instant Client for Linux x86-64
From the Oracle Database 12c Release 2 (12.2) New Features Guide: Adding Oracle Data Pump and SQL*Loader Utilities to Instant Client This feature adds SQL*Loader, expdp, impdp, exp, and imp to the tools for instant client. Now you can run these utilities on machines that…
Enterprise Manager 13cR2 – How to apply Patch 23094292: WLS PATCH SET UPDATE 12.1.3.0.160719
My fresh EM13cR2 installation showed me that there is a patch for the Weblogic environment available. This patch was released in July 2016: Patch Patch 23094292: WLS PATCH SET UPDATE 12.1.3.0.160719. This patchset has included 157 fixes and is a generic one. The patch is…
Row pattern matching nested within hierarchy
I’ve been playing around with MATCH_RECOGNIZE – the data pattern matching extension to SELECT that was introduced in version 12. Most examples I’ve seen have used the default AFTER MATCH SKIP PAST LAST ROW as most often the logic dictates, that when we have found…