Relational Data Management - Partition, Compress, Storage Tier and Snap Clone your way to success

We are finding a lot of customers are answering yes to most of the following questions:

1. Is your growing data volume inhibiting application performance?
2. How long will it be before your database doubles in size?
3. Are you required to retain data for extended periods and still make it accessible to end users?
4. Do you have multiple full size copies of production databases for test, development, training, etc?
5. Is storage consuming an increasing portion of your IT budget?

To quantify this problem we can run some scripts which generate an easy to assimilate graphical report, for example.

What can be done?

• Data Partitioning can reduce the active database footprint by 40% for most transaction based applications including E-Business Suite, Siebel and PeopleSoft
• Data Compression can reduce transaction data storage consumption by 30%
• Tiered Storage can reduce storage costs by 73% over premium storage whilst improving performance
• Snap Clone can decimate the storage costs for non-production database copies and reduce provisioning time

This is one of those rare problems where the solution can save money and improve performance.   Let me know if you would like a similar report for one of your growing Oracle OLTP databases.