My Oracle Support Banner

Poor performance with HCC QUERY HIGH when accessing Index ROWID (Doc ID 2519371.1)

Last updated on JANUARY 16, 2020

Applies to:

Oracle Exadata Storage Server Software - Version 12.1.2.1.1 and later
Information in this document applies to any platform.

Symptoms

Experiencing query performance degradation after compressing table partitions.

Applicable to - RDBMS 11.2.0.4 Apr/16 BP

Changes

Compress with QUERY HIGH and access the parition.

alter table SCOTT.EMP move partition P1 tablespace USERS compress for query high parallel (degree 4) ;

alter index SCOTT.PK_EMPID rebuild partition P tablespace USERS parallel 4 ;

exec dbms_stats.gather_table_stats(ownname=>'SCOTT',tabname=>'EMP', partname=>'P',granularity=>'PARTITION',degree=>4, force => true);

Select the parition....

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.