Database DataWarehousing (MOSC)

MOSC Banner

oracle compression

edited Mar 14, 2010 10:36PM in Database DataWarehousing (MOSC) 3 commentsAnswered
 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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center