Whitepaper Update: Database Partitioning for E-Business Suite
By Steven Chan (Oracle Development) on Apr 21, 2009
Maintaining your existing service level agreements with your users becomes increasingly challenging as your E-Business Suite database grows. The knee-jerk reaction to a performance problem is often to throw more hardware at it. If you have a large E-Business Suite environment where the growth rate of your historical transactional data is starting to affect performance, there's another alternative to scaling up your hardware. It's possible that you could use database partitioning to squeeze some additional performance out of your existing environment without the added expense of new hardware.
Our Applications Performance Group released a whitepaper on database partitioning for Apps environments last year. Our Applications Technology Integration group has since teamed up with them to put that whitepaper through a major rewrite. It's available here:
- Database Partitioning for Oracle E-Business Suite (Metalink Note 554539.1)
The changes to this whitepaper include fine-tuning of conceptual material, richer technical examples, and more-detailed implementation guidance and advice.