oracle compression
Hi Tom,
I have tested the 11g oltp compression and not really happy with the results as claimed in oracle pdf document where it talks about 2, 3 times rate.
My results
1.I did not get more than 30% on avg compression. (The same tables yields 50% compression on avg from basic compression alter table move compress...)
2. queries performing full scan also takes a bit longer on oltp compressed tables.
3. Likewise cpu also increased a bit.
I WONDER who would use oltp compression at the a) additional cost of its licensing $10k per cpu, b) additional cost of machine cpu (which increases oracle licensing) c) full scans taking more time.
I have tested the 11g oltp compression and not really happy with the results as claimed in oracle pdf document where it talks about 2, 3 times rate.
My results
1.I did not get more than 30% on avg compression. (The same tables yields 50% compression on avg from basic compression alter table move compress...)
2. queries performing full scan also takes a bit longer on oltp compressed tables.
3. Likewise cpu also increased a bit.
I WONDER who would use oltp compression at the a) additional cost of its licensing $10k per cpu, b) additional cost of machine cpu (which increases oracle licensing) c) full scans taking more time.
0