Exadata: Updates against the EHCC tables are slow after the 12cR2 upgrade.

(Doc ID 2323529.1)

Last updated on OCTOBER 31, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 to 12.2.0.1 [Release 12.2]
Information in this document applies to any platform.

Symptoms

DMLs (updates) against the Exadata Hybrid Columnar Compressed(EHCC) tables may report significant performance issues after the database 12.2 upgrade. The SQL trace would indicate a the huge number of buffer gets during the DML operation though there is no execution plan change after the 12.2 upgrade.

And the excessive time is spent on CPU utilization.

 

  

Changes

Database upgrade to 12cR2 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms