How To Speed Up The Upgrade Process On An Agile Product Lifecycle Management (PLM) System When History Tables Over 50Gb?
(Doc ID 2761829.1)
Last updated on MARCH 23, 2021
Applies to:
Oracle Agile PLM Framework - Version 9.3.6.0 and laterInformation in this document applies to any platform.
Goal
The Agile History Tables - CHANGE_HISTORY, ADMIN_HISTORY_DETAILS, ITEM_HISTORY, EVENT_HISTORY, A_DW_TXN_LOG are well over 50 GB alone and stall out when trying to import the database across an Network File System (NFS) mount. Need suggestions on how to archive the data in these tables to reduce the size. The remaining tables are less than 16GB when these tables are truncated. Customer is using Automated Upgrade Tool (AUT) with the default setting "sourceEqualsDest = false".
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |