My Oracle Support Banner

Will Upgrade Perform Faster by Pre-Allocating Extent To AP_INVOICE_DISTRIBUTIONS_ALL ? (Doc ID 1900725.1)

Last updated on JANUARY 16, 2018

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

Looking for out of the box ideas to cut down the timeline for an R12 upgrade.

Currently size is 750 million rows in the AP_INVOICE_DISTRIBUTIONS_ALL table
and another 700 million rows in the AP_CHRG_ALLOCATIONS table.

Would it make a substantial difference in the upgrade time
if space is pre-allocated to AP_INVOICE_DISTRIBUTIONS_ALL ?
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.