I have a question related to Exadata. Why are the new rows that are inserted into the compressed table not getting compressed? It is it like I need to compress it again.
Exadata Hybrid Columnar Compression only does compressions on direct load operations, so rows added with INSERT operations will not be compressed.
Dig Deeper on Oracle database performance problems and tuning
Related Q&A from Rick Greenwald
One reader asks Oracle Exadata book co-author Rick Greenwald about the SGA caching dynamic in Exadata. Continue Reading
One reader asks whether Cache Fusion for Oracle RAC is implemented differently on Oracle Exadata compared to other platforms. Continue Reading