My Oracle Support Banner

DBMS_SPACE_ADMIN enhancement to avoid running the compression advisor on table(s) with LOB column(s) (Doc ID 2184920.1)

Last updated on FEBRUARY 23, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.2 BETA1 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

Purpose

As part of the segment advisor, the compression advisor runs. If a table has LOB column(s), the compression advisor may be slow.

Prior to 12.2, the segment advisor does not check if the table has LOB column(s) before calling the compression advisor and hence the segment advisor performance may be negatively affected for these tables.

Details

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
Purpose
Details
 How enhancement is implemented?
 Test Case
 Observation
 Conclusion
References

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