Whitepaper Update: Database Partitioning for E-Business Suite

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.

Database Partitioning Methods:

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:

The changes to this whitepaper include fine-tuning of conceptual material, richer technical examples, and more-detailed implementation guidance and advice.

Related Articles

Comments:

Hi Steven & Team,

We are interested in looking at how various partitioning approaches could help our EBS performance (primarily reporting/inquiry is where our performance is dragging).

We run a shared-services, single DB R12.1.3 environment w/18 independent ledgers & supporting Operating units (w/plans to continue adding more). Our ledgers represent totally independent entities and reporting is never done across multiple ledgers. We want to try to get as smart as possible on what partitioning strategies would make the most sense to implement, considering the multi-ledger nature of our environment. At first it seems like a no-brainer to partition key tables by ledger_id/org_id and then look at sub-partitions below that (i.e. by period or whatever depending on the tables). But we still have a good bit more work to do to validate the approaches that would make the most sense.

Just wanted to reach-out to see if there might be any known EBS Partitioning Best Practices/Resources you could point us to that we should be sure to look at, specifically around multiple, independent ledger configurations. We are familiar with the MOS Note/WhitePaper - Using Database Partitioning with Oracle E-Business Suite [ID 554539.1], but just curious if there might be anything else out there.

Thanks!

Larry

Posted by Larry Baugh on March 21, 2013 at 09:49 AM PDT #

Hi, Larry,

The Note that you've cited contains our latest guidance on database partitioning in EBS environments.

At the risk of being overly reductive, I can tell you that database partitioning can have dramatic effects -- both positive and potentially negative -- on your environment's performance. Careful performance testing using workload curves that represent your production load is always recommended when you do these types of customizations.

Regards,
Steven

Posted by Steven Chan on March 27, 2013 at 09:06 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
4
5
6
7
8
9
10
11
12
13
14
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today