Exadata: Updates against the EHCC tables are slow after the 12cR2 upgrade.
Last updated on OCTOBER 31, 2017
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 to 184.108.40.206 [Release 12.2]
Information in this document applies to any platform.
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.
Database upgrade to 12cR2
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