Forum Stats

  • 3,875,761 Users
  • 2,266,969 Discussions
  • 7,912,335 Comments

Discussions

Compression of static DW data

User_DJTAT
User_DJTAT Member Posts: 1 Employee
edited Nov 10, 2010 4:44AM in Advanced Compression
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

Answers

This discussion has been closed.