Skip to Main Content

Database Software

Compression of static DW data

User_DJTATNov 1 2010 — edited Nov 10 2010
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."

Question:

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?

Thanks,
Greg
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 8 2010
Added on Nov 1 2010
1 comment
1,190 views