Direct INSERTs into HCC tables may be slower since Oracle 12.2

I work with several customers at the moment on their Oracle 12.2/18c “go live” projects. And one of these customers encountered a strange issue when comparing Oracle 11.2.0.4 to Oracle 12.2.0.1/18.3.0: Direct INSERTs into HCC tables may be slower since Oracle 12.2. Actually in this particular case, significantly slower. Read below why this can happen and how the workarounds look like. Hybrid Columnar Compression There’s a lot of material to read and study about Hybrid Columnar Compression (HCC). With HCC we store the same column for a group of rows together. The data block does not store data in row-major…

When will Oracle Database 18c be available on-prem?

When will Oracle Database 18c be available on-prem? Some of you will answer: It is available already, isn’t it? And you are right. But I don’t want to blog just a marketing message but some facts. Others may ask: When will it be generally available on-premises? ==> July 23, 2018: Linux 18.3.0 on-prem is available – please click here <== When will Oracle Database 18c be available on-prem? As of today, March 20, 2018, Oracle Database 18c is available already in/for: OCI and OCI-C Database services LiveSQL.oracle.com Oracle Exadata and SuperCluster on premises Oracle Database Appliance (ODA) on premises Actually…

PERL scripts for large migrations supported on all platforms (except Windows)

This topic fits very well as I present about +100 TB migrations today at the “Harmony” User Group Conference in Finland. The question whether the PERL scripts for RMAN incrementally rolled forward backups we deliver via MOS Note 1389592.1 (11G – Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backup) will be supported for migrations to non-Exadata systems such as Oracle SuperCluster as well. And yes, now we got an update into the note saying: Although preferred destination system is Linux (either 64-bit Oracle Linux or a certified version of RedHat Linux), this procedure can be used with other Unix…

Oracle Database 12.2 for Exadata/SuperCluster available

Oracle Database 12.2.0.1 on-premises for Exadata and SuperCluster is now available for download from Oracle eDelivery/SoftwareCloud. Connect to eDelivery and login. Search for: “Oracle Database” and mark “Oracle Database Enterprise Edition …” . Click on “Select Platforms” and select “Linux x86-64“, then hit “Continue“: Once you accepted the license agreement you’ll be able to download the software: Please be aware that the software can be installed on Oracle Exadata and Oracle SuperCluster ONLY. To take advantage of the full potential of Oracle Database 12c Release 2 you should upgrade to the latest Exadata Software Release 12.2.1.1.0 before upgrading databases to…

Patches, Patch Sets, Patch Bundles, Bundled Patches …

Ouch … just realized that it has been a while since I posted a new topic on the blog. But actually the past weeks I was busy doing workshops, working with customers – and finally (yes!!) participating on an Exadata training class. Sitting there for 3 days, listening the instructor, playing around with the cell simulator and all the exercises was quite a nice change from the daily business. And I believe I’ve learnt something useful 🙂 Well, daily business, this brings me back to a topic which hit my inbox today again for the 2nd time in a few…