This discussion is archived
3 Replies Latest reply: May 8, 2013 8:50 AM by Hussein Sawwan-Oracle RSS

custom partitioning

jeffb1 Newbie
Currently Being Moderated
Seeking others who have implemented custom partitioning of the EBS. If you have done so:
- why?
- what benefits were achieved?
- what objects did you partition and why?
  • 1. Re: custom partitioning
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    jeffb1 wrote:
    Seeking others who have implemented custom partitioning of the EBS. If you have done so:
    - why?
    - what benefits were achieved?
    - what objects did you partition and why?
    Using Database Partitioning with Oracle E-Business Suite [ID 554539.1]

    https://blogs.oracle.com/stevenChan/entry/ebs_sun_virtualization
    https://blogs.oracle.com/stevenChan/entry/new_whitepaper_database_partit
    https://blogs.oracle.com/stevenChan/entry/whitepaper_update_database_partitioning_for_ebusin
    https://blogs.oracle.com/stevenChan/entry/using_database_partitioning_wi
    https://blogs.oracle.com/stevenChan/entry/partitioning_and_purging_best
    https://blogs.oracle.com/stevenChan/entry/whitepaper_options_for_reducing_ebs_database_size
    https://blogs.oracle.com/stevenChan/entry/using_advanced_compression_with_e-business_suite

    Thanks,
    Hussein
  • 2. Re: custom partitioning
    jeffb1 Newbie
    Currently Being Moderated
    I had seen those articles and they are 5-6 years old. Given that the EBS mainly accesses the tables via an index, how would partition pruning be a help?
  • 3. Re: custom partitioning
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    jeffb1 wrote:
    I had seen those articles and they are 5-6 years old. Given that the EBS mainly accesses the tables via an index, how would partition pruning be a help?
    Partitioning is not a new technology and the modified date of the doc referenced above is "Aug 28, 2012".

    Have you checked the PDF files attached in the doc?

    Thanks,
    Hussein

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points