This content has been marked as final. Show 1 reply
Table compression does not require any additional licenses the key is that the only compression is done via direct insert pretty good for a data warehouse. To get and maintain compression for regular inserts and for updates an Advanced Compression license is required.
Performance for inserts using direct method does not appear to have any large impact to load performance, however updates and regular inserts do take a bit of a hit when using compression. Queries that have any significant IO operations appear to benefit the most from compression and the larger the number of IO operations the higher the performance impact tends to be. Keep in mind that compression does take a CPU hit for the compression and de-compression operations, while this does not appear to be really large it is a consideration if your system have CPU resource issues already.
I have found that partitioning and compression when used together offers the best performance when accessing using the partition key and partitioning offers benefits for management as well, found range/interval partitioning offered the best management benefits for a data warehouse.
Some references besides the documentation which is a decent place to start, also google searches on Oracle Advanced Compression returns tons of results:
Looks at table compression and 11g Advanced compression
Basic Exaplinations and examples for compression