Documents

Storage Optimisation with Partitioning & Advanced Compression

Whitepaper: Smaller & Faster

Oracle Database 11gR2 Reducing Storage Cost and Improving Performance

With research showing the average database is expected to double in size every couple of years and multi-terabyte databases fast becoming the norm; together with the need to gain access to this data faster than ever, there is now more than ever a need for IT Departments to be aware of the solutions available to them to address these issues. At the same time pressure is mounting on IT Departments to show their green credentials by reducing their data centre cost, of which storage facilities takes up a significant chunk.

Oracle 11gR2 offers the DBA more choice than ever when it comes to compression and partitioning. This whitepaper discusses the various partitioning and compression options available in this release and uses case studies to demonstrate how these technologies can be implemented with little effort and little to no change to the application to achieve this mantra of “Smaller and Faster”; and provide compelling evidence that these technologies are fast becoming essential tools rather than nice to haves.

   Download this document