Multihop migration estimates for Release 8.5 to Release 9.1

The time it takes to perform a multihop upgrade from Release 8.5 to Release 9.1 varies, because of numerous factors. It is therefore recommended that you use the information in this section as a rough estimate, and not as a guarantee. In order to help you more precisely determine the time it takes to perform a multihop upgrade from Release 8.5 to Release 9.1, this section provides two migration estimates that are based on different data amounts.

The following hardware configuration was used to arrive at the time estimates:

DB Version: 11.2.0.1.0

DB Server OS: RHEL 5.3

Class of the DB Server: PowerEdge R900

Number of CPUs on the DB Server: 2 Quad 2.4 GHz processors

RAM on Database Server: 16 GB

Disks Used for Database Files: EMC CLARiiON CX4-80 SANS

Disk Filesystem: ASM

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

Database Server

First migration estimate: row counts for key tables

The premigration total data size is ~ 272 GB, and the postmigration total data size is ~ 273 GB. Table 1 provides row counts for key tables in the sample database for Release 8.5. These row counts are based on tables with > 500,000 records.

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

First migration estimate

Table 2 provides time estimates pertaining to the migration process based on the data in Table 1.

Table 2. Migration estimates
Time Task
< 1 min copyextensions
~ 2 mins initupgrade
< 1 min migration-validation
< 1 min alter-history-tables
~ 3 mins install-history-indexes
< 1 min upgrade-history-tables
< 1 min alter-transaction-tables
~ 2 mins install-transaction-indexes
~ 2 mins upgrade-transaction-tables
< 1 min migrate-doc-params
< 1 min validate-upgrade
< 1 min run-history-drop
~ 1 min run-transaction-drop

Second migration estimate: row counts for key tables

The premigration total data size is ~ 1415 GB, and the postmigration total data size is ~ 1416 GB. Table 3 provides row counts for key tables in the sample database for Release 8.5. These row counts are based on tables with > 500,000 records.

Table 3. Row counts for key tables in the sample database
Data Current Data Size History Data Size
Number of Orders 7793592 N/A
Number of Order Lines 30949125 N/A
Number of Shipments 35928131 N/A
Number of Items 254358 N/A
Number of Inventory Items 10914 N/A
Number of Resource Pool Capacity Consumptions 46094042  

Second migration estimate

Table 4 provides time estimates pertaining to the migration process based on the data in Table 3.

Table 4. Migration estimates
Time Task
< 1 min copyextensions
~ 11 mins initupgrade
< 1 min migration-validation
< 1 min alter-history-tables
~ 2 mins install-history-indexes
< 1 min upgrade-history-tables
< 1 min alter-transaction-tables
~ 12 mins install-transaction-indexes
~ 47 mins upgrade-transaction-tables
< 1 min migrate-doc-params
< 1 min validate-upgrade
< 1 min run-history-drop
~ 1 min run-transaction-drop