Is There Any Negative Impact Because of Database Compression? (Doc ID 1642814.1)

Last updated on JUNE 12, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 and later
Information in this document applies to any platform.
*** Checked for relevance on 06-12-2017 ***

Goal

To understand if BRM has any negative impact because of database compression.

Performance was improved for billing if BRM tables are compressed at Database level.

As an example:
-  created tables in Oracle database with compressed option, e.g. use "COMPRESS FOR OLTP LOGGING" for all the tables.
-  did not compress any index.

 

Solution

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