Hello all;
- In one of my recent upgrade projects involving an 8TB Oracle database, I observed that the import operation is taking approximately 62 hours to complete.
- Within this, importing INDEXES alone consumes around 21 hours, and importing CONSTRAINTS takes about 24 hours.
- I am looking for best practices, tips, or any suggestions to help reduce the overall import time, especially for these long-running segments. If anyone has experience with speeding up large database imports or optimizing the import of indexes and constraints, your insights will be highly appreciated.
- Currently, the import is a major bottleneck in the upgrade timeline, and any guidance on parallelism settings, pre/post-import tuning, or other techniques would be very helpful. Thank you in advance!
Note:
- Here I've used PARALLEL=30 as well [ 32 CPU Database server ]
- INDEXES
- CONSTRAINTS
BR!
/Dilshan