|
|
|
|
|
|
| Re: Standard vs Advanced Compression [message #475089 is a reply to message #472033] |
Sun, 12 September 2010 18:45  |
 |
Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA
|
Senior Member |
|
|
The best way to handle this is three fold:
1) you need to read the documentation. In particular look for the Oracle White Papers. This will explain what basic compression is and what advanced compression is.
2) you should then read other people's experiences with it. There are many people reporting that advanced compression is way too expensive from a performance perspective for their systems. There are other's reporting that the success of ADVANCED COMPRESSION depends heavily upon your specific data. There is also a study by some guy (can't find the link right now) where he does a pretty good job of testing it out with some reasonable conclusions.
3) you need to try it on your own to see if it will work for you. There will be no way around this.
** I would note however, that advanced compression is an EXTRA COST item that you will have to buy seperately from your current licenses. Even if you can get it to work with out incurring significant drops in transaction throughput, you will still have to figure out if it is cost effective. Some have suggested that you need databases in the multiple terrabyte size (not GB, but TB) in order to make ADVANCED COMRPESSION worth purchasing. As you can see it has a specific target group. Are you in this group?
Good luck, Kevin
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
