What would you do to compress data in partitions that are frequently updated in Oracle Database 11g?

What would you do to compress data in partitions that are frequently updated in Oracle Database
11g?

What would you do to compress data in partitions that are frequently updated in Oracle Database
11g?

A.
Use Hybrid Columnar Compression.

B.
Use Advanced Compression Option.

C.
Use Hybrid Partitions.

D.
Avoid compressing any data.

Explanation:
Advanced Compression features in Oracle Database 11g include:
* Online Transaction Processing (OLTP) Table Compression: This breakthrough
compression feature compresses table data during all types of data manipulation
operations, including conventional INSERT or UPDATE. OLTP Table
Compression leverages a sophisticated and intelligent algorithm that minimizes

compression overhead during write operations, thereby making it viable for
highly transactional workloads
Reference: Oracle Advanced Compression, Oracle Data Sheet
Hybrid Columnar Compression (HCC) on Exadata, Oracle White Paper



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Roman

Roman

D.Avoid compressing any data.