Oracle Database 12c Advanced Compression provides features designed to compress structured data (Advanced Row Compression), unstructured data (Advanced LOB Deduplication and Compression), database backups (RMAN and Data Pump Compression), and network traffic (Data Guard Redo Log Transport and Advanced Network Compression).
Our EBS architects have released a new whitepaper that focuses on Advanced Row Compression:
- Oracle E-Business Suite 12.2 with Oracle Database 12c Release 1 Advanced Row Compression (Note 2458161.1)
This whitepaper quantifies the storage benefits for Oracle E-Business Suite and documents its effect on performance. Advanced Row Compression can reduce your current storage requirements as well as defer the future purchase and integration of additional storage. It includes optimization for Flashback Data Archive (FDA) history tables, which reduces the storage requirements for using FDA to track changes to tables.
Importantly, Advanced Row Compression is completely transparent to Oracle E-Business Suite and can even be used with Transparent Data Encryption (TDE) tablespace encryption because compression is applied before the data blocks are encrypted. The compression ratio depends on the data being compressed and more specifically the cardinality of the data. Customers have reported a reduction in storage by a factor of 2x to 4x across a range of systems. This new white paper examines whether this is the case for Oracle E-Business Suite.
Related Articles