Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

I am already using the Table Compression feature introduced in Oracle9i. What additional benefits do I get from Advanced Compression option?

April 26, 2017additional advanced Benefits compression feature introduced option oracle9i Table

0

Posted

I am already using the Table Compression feature introduced in Oracle9i. What additional benefits do I get from Advanced Compression option?

1 Answer

0

Posted

With Table Compression feature of Oracle9i Database, one could only compress table data during bulk load operations. With Advanced Compression, new and modified data is also compressed. Further, Advanced Compression includes compression and deduplication of SecureFiles. This can provide significant savings for applications that were storing unstructured data as LOBs in previous versions. Improved compression for backups and compression of redo logs are the other capabilities available only with Advanced Compression option.