3 Replies Latest reply: May 8, 2013 10:50 AM by Hussein Sawwan-Oracle RSS

    custom partitioning

    jeffb1
      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
          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
            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
              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