Migration estimates for Release 8.2

The time it takes to upgrade from Release 8.0 to Release 8.2 varies, because of numerous factors. It is therefore recommended that you use the information in Table 2 as a rough estimate, and not as a guarantee. The following hardware configuration was used to arrive at these time estimates:

DB Version: 10.2.0.1

DB Server OS: HP-UX 11.11

Class of the DB Server: rp7410

Number of CPUs on the DB Server: 8 (750 MHz processors)

RAM on Database Server: 8 GB

Disks Used for Database Files: EMC CLARiiON FC4700 SANS

Disk Filesystem: RAW

Application Server (The server on which the migration program was run):

Database Server

Total Data Size premigration: ~ 342.2 GB

Total Data Size postmigration: ~ 348.5 GB

Row counts for key tables

Table 1 provides row counts for key tables in the sample database for Release 8.2.

Table 1. Row counts for key tables in the sample database
Data Current Data Size History Data Size
Number of Orders 2020646 3646369
Number of Order Lines 3407941 7207180
Number of Shipments 2665353 5121472
Number of Items 1201544 N/A
Number of Inventory Items 286670 N/A
Number of Receipts 177848 N/A

Migration estimates

Table 2 provides time estimates pertaining to the migration process.

Table 2. Migration estimates
Time Task
~ 12 mins initupgrade
< 1 min migration-validation
~ 50 mins alter-history-tables
~ 5 mins upgrade-history-tables that include the following tasks:

- prehistory-migration

- migrate-history-data

- post-history-migration

~ 1 min create unique indexes - history tables
~ 50 mins alter-transaction-tables
~ 10 mins upgrade-transaction-tables that include the following tasks:

- pre-transaction-migration

- migrate-transaction-data

- post-transaction-migration

- apply-fc-setup

~ 1 min create unique indexes-transaction tables
~ 110 mins create nonunique indexes-history tables
~ 45 mins create nonunique indexes-transaction tables