The time it takes to upgrade from Release 7.11 to Release 8.0 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
Table 1 provides row counts for key tables in the sample database in Release 8.0.
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.
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 |