My Oracle Support Banner

Compression At Table Space Level (Doc ID 2573242.1)

Last updated on AUGUST 02, 2019

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.7.0.0.0 and later
Information in this document applies to any platform.

Goal

Qn1:1. The document says advanced compression is supported at both table and tablespace level. But if we do it at at tablespace level(in this case CISTS_01 tablespace), there might be some tables that my have huge dml activity and advanced compression is usually not recommended for tables with high dmls. So, how this is taken care of in ORMB 2.8?

Qn2:Can we just have NO compression at tablespace level and compress only those tables which are good candidate of advanced compression. If this is doable ,then how?
 

Solution

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
Goal
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.