Hello All-
I need some suggestions as how to improve the import of a single schema in terms of time taken to complete the import.
Export (11.2.0.3) is done with 2 USER schemas with parallel option set to '6' and completes in 45-50 mins on an average is acceptable time.
Import(12.1.0.1.0) with the above created 6 dmp files of only 1 USER schema is taking more than 4 hrs and is being performed with PARALLEL=8.
My question I have read that we need to have this parallel option closer to the number of files created by export but can I increase to say 10 ?