Oracle database 19c Compression Types
We had multiple requirement for Compression hence documenting handy notes that can help myself and others . To automate compression we have feature of Oracle Automatic Data Optimisation which we will discuss later ==> Compression types : We can know type of compression from below sql SQL> select name, currently_used from dba_feature_usage_statistics where lower(name) like ‘%compress%’; BASIC compression, introduced in Oracle 8 already and only recommended for Data Warehouse OLTP compression, introduced in Oracle 11 and recommended for OLTP Databases as well QUERY LOW compression (Exadata only), recommended for Data Warehouse with Load Time as a critical factor QUERY HIGH compression (Exadata only), recommended for Data Warehouse with focus on Space Saving ARCHIVE LOW compression (Exadata only), recommended for Archival Data with Load Time as a critical factor A...