Compression of static DW data
Hello, a simple question for some of you I'm sure,
"Oracle compresses a block in batch mode rather than compressing data every single time a write operation takes place. When a transaction causes the data in the block to reach an internally controlled threshold, all contents of the block are compressed. Only the transactions that trigger compression of the block will experience the minimal compression overhead."
If you have a data warehouse with a large percentage of static data, is it possible that static blocks will not reach this threshold and thus might never be compressed?