By Steven Chan (Oracle Development) on May 28, 2010
In my opinion, if there's any reason to upgrade an E-Business Suite environment to the 11gR1 or 11gR2 database, it's the Advanced Compression database option. Oracle Advanced Compression was introduced in Oracle Database 11g, and allows you to compress structured data (numbers, characters) as well as unstructured data (documents, spreadsheets, XML and other files). It provides enhanced compression for database backups and also includes network compression for faster synchronization with standby databases.
In other words, the promise of Advanced Compression is that it can make your E-Business Suite database smaller and faster. But how well does it actually deliver on that promise?
Apps 12 + Advanced Compression Benchmarks now available
Three of my colleagues, Uday Moogala, Lester Gutierrez, and Andy Tremayne, have been benchmarking Oracle E-Business Suite Release 12 with Advanced Compression 11gR1. They've just released a detailed whitepaper with their benchmarking results and recommendations.
This whitepaper is available in two locations:
- Oracle E-Business Suite Release 12.1 with Oracle Database 11g Advanced Compression (Note 1110648.1) (requires My Oracle Support access)
E-Business Suite Release 12.1 with Oracle Database 11g Advanced
Compression (Applications Benchmark website, PDF, 500K)
The results, even with our EBS Vision demonstration database, were impressive:
- Reduced 21.9 GB of tables down to 6.9 GB (68% reduction, average 3:1 compression ratio)
- Self-service performance improved up to 36%
- Purchasing performance improved up to 10%
- Order-to-Cash batch flow performance improved up to 33%
- Payroll performance improved up to 25%
- Some SQL execution plans changed, reducing performance
- Performance was improved at the cost of up to 6% increased CPU usage, with the variance depending upon how much DML is performed
- In the case of
the Order-to-Cash batch flow, the average CPU consumption actually decreased
Oracle using this in production with EBS 12 today
We can now share the news that we've been using Advanced Compression in our Oracle Global Single Instance (GSI) production environment since 2009. This same team has been working to analyse the results of using Advanced Compression with our Oracle E-Business Suite Release 12 global single instance that we use to run Oracle's own business.
The results there are very impressive:
- Reduced EBS 12 database size from 17 Terabytes to
- Compressed ~260 tables and over 700 associated indices and LOBs after migrating to SecureFiles
- Total space saved: 68 TB across our primary, standby, and associated testbeds
This whitepaper makes detailed E-Business Suite-specific observations in the following areas:
- Index compression
- Recommended patches
- SQL Plan regression analysis
- DML intensive operations
- Row chaining on UPDATE transactions
- High transaction tables
- SecureFiles LOB compression
Have you used Advanced Compression with EBS?
Naturally, compression ratios and performance impacts or benefits will vary for every Apps environment. If you've used this technology, we're very interested in hearing about your experiences with Advanced Compression in your environment. You're invited to share your experiences here or drop me an email directly.
- Using Advanced Compression with E-Business Suite Databases
- 11gR2 Database Certified with E-Business Suite 11i
Database Certified with E-Business Suite 12
+ 11g Database Upgrade Best Practices Whitepaper Available
Premier Support for 10gR2 10.2.0.4 Database ends July 2010