Wednesday, August 24, 2022

Oracle E-Business Suite Release 12 Upgrade Sizing and Best Practices (Doc ID 399362.1)

 This document looks at several key aspects of upgrading Oracle E-Business Suite Release 12.

The core of this document is the set of six attachments that contain information on the following topics: tablespace sizing, schema sizing, post-upgrade historical Financials documents (optional), best practices to manage the upgrade of Release 12, required post-upgrade concurrent jobs, and sample upgrade timings.

The database upgrade statistics are from the upgrade of a 6.5 TB Oracle E-Business Suite Release 11.5.10 CU2 database.

There is a change log at the end of this document.

Attachments To This Document

Click on one of the following links to open or download an attachment:

These attachments are also listed at the bottom of this document.

Database Upgrade Statistics

Years of Data MigratedDatabase Size (GB) Before Upgrade
Database Size (GB) After Upgrade
Delta (GB)
% Growth
36609.976808.44198.473
126609.977161.61551.648.3

The first column, "Years of Data Migrated" refers to the number of financial periods (in units of years) selected to be migrated during the actual upgrade phase. For example, three years of Financials data refers to upgrading Financials documents such as Payables, Receivables, Costing, Projects, and Fixed Assets for the periods from 2004 through to 2006.

Note: During upgrade of the admin tier, batchsize was 10,000 and number of workers used was 30.

No comments:

Post a Comment

Database Options/Management Packs Usage Reporting for Oracle Databases 11.2 and later (Doc ID 1317265.1)

  Database Options/Management Packs Usage Report You can determine whether an option is currently in use in a database by running options_pa...