Parallel export
Expdp cs/cs @ former directory=dumpdir dumpfile=cs_ % U.d mp log=cs. The log filesize parallel=4 full==10 g y
Parallel import
Impdp cs/cs @ former directory=dumpdir dumpfile=cs_ % U.d mp log=cs_out. The log parallel=4
But there is a problem, if the export with single thread only generates a file, then import when I set up a multi-threaded, we import the actual use is single-threaded or multithreaded add set?
What a great god can help me to explain it in detail, if you have the official explanation so much the better
CodePudding user response:
After tests found can indeed single-threaded export multi-threaded import, multithreading import, through the status to see the multiple threads are import different objects at the same time, the test if only import table structure found in multi-threaded not parallel, are in a wait state,), so even if no multithreading, export import time can also be a multithreaded, guide together fast but there is more data files,