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
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.
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 |
Table 2 provides time estimates pertaining to the migration process based on the data in Table 1.
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 |
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.
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 |
Table 4 provides time estimates pertaining to the migration process based on the data in Table 3.
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 |