Poorly Performing Materialized-View Refresh With Index Compression High
(Doc ID 2677070.1)
Last updated on JANUARY 19, 2022
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
After introducing compression and encryption (for HIPAA compliance), a complete materialized-view refresh of million rows is running for at least nineteen hours and not completing.
The DDL in question is:
INSERT /*+ BYPASS_RECURSIVE_CHECK */
SQL ID: 4pg5cdvctcd53
Was invoked by SQL_ID cks88p3q530h8:
LIST => '<<<
,METHOD => 'C'
,PUSH_DEFERRED_RPC => TRUE
,REFRESH_AFTER_ERRORS => FALSE
,PURGE_OPTION => 1
,PARALLELISM => 0
,ATOMIC_REFRESH => TRUE
,NESTED => FALSE
,OUT_OF_PLACE => FALSE
,SKIP_EXT_DATA => FALSE);
This database was migrated via Data Pump to a different host.
Compression and Encryption was introduced (for HIPAA compliance).
The index on the Mview was compressed using COMPRESS ADVANCED HIGH.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document