Like to know if someone ever used the Oracle option to compress tables. What was the result (compression ratio)? Was there any impact on the performance (positive or negative)?

Regards,
Han

Han,

We have not used yet, I came across documents which had some information on the topic:

Performance, Tracing and Tuning Guide
Document code: U9357A US
Release: Infor ERP LN
Publication date: November 07
Chapter 5 : Tuning Oracle
Oracle Compression 5-10

Oracle Compression for Infor ERP LN
Document code: B0050A US
Release: Infor ERP LN
Publication date: September 07

SolutionID 224038 CreatedBy Boot,Bram
CreatedOn 2007-09-20 ModifiedByBoot,Bram
ModifiedOn 2007-09-20 VerifiedBy

VerifiedOn StatusDescription
Published TypeDescription
KR: Question

Solution Description
English Oracle compression information for ERP LN
VERSION(S): Infor ERP LN running under Oracle database.

SITUATION IDENTIFIED IN: "Oracle compression" (Infor ERP LN)

SITUATION DESCRIPTION:
Oracle compression has been available since Oracle 9.2. It is a utility to reduce the size and growth of databases. More information is needed of the application of this data base utility for Infor ERP LN.


SOLUTION DESCRIPTION:
The 'Oracle Compression for Infor ERP LN' (B0050A US) document which is linked to this solution explains the usage of Oracle compression techniques for Infor ERP LN to reduce the size and growth of databases. The document also contains some benchmark results.

SPECIAL INSTRUCTIONS: None.

PATH NAME IN DIAL-UP DIRECTORY/WEB SITE:
Below are the supported VRC's based on the Baan standard derivation structures. It is necessary to download and patch all links contained under the VRC in the order listed. The solutions may contain standard and localized components, which require multiple ftp links.

If your Current VRC is: 6.1_a3:
/ftpdownload/updates/Documents/b0050aus.pdf

Like to know if someone ever used the Oracle option to compress tables. What was the result (compression ratio)? Was there any impact on the performance (positive or negative)?

Regards,
Han

I recently heard a problem with compression in 10g: it seems that when you add columns the new bdbreconfig can give the following error:

oerr ora 39726
39726, 00000, "unsupported add/drop column operation on compressed tables"
// *Cause: An unsupported add/drop column operation for compressed table
// was attemped.
// *Action: When adding a column, do not specify a default value.
// DROP column is only supported in the form of SET UNUSED column
// (meta-data drop column).


And some related errors. Nasty problem. Most likely workaround for this:
- bdbpre
- bdbpost
- reconfig
- compress

A real bummer as the fast reconfig was meant for very large tables and also the compress makes mostly sense for huge tables. Hopefully Oracle solves this issue soon.

If you can life with this, it works great.

Best regards,
Dick

tfgld481 seems to be good candidate for compression in LN6.1. Compression ratio is huge....dat from 60GB to 1,5GB in Unicode.
This table is replaced by gld465.

As tfgld465 is indeed the replacement of tfldgld481, indeed this table should be added to the list of candidates to be compressed. Good remark.