How to get around the single threaded PDB archive process?
For: Oracle RDBMS (all editions) 19c (using 19.17)
I have an outstanding Oracle service request (SR) that I logged over a year ago and I still do not have an answer from Oracle support about this. So I'm reaching out to see if anyone in Oracle land has come up with a reasonable workaround.
Basically, if you do something like the following two steps you will create a PDB archive using Oracle's single threaded unplug operation:
alter pluggable database PDB1 close immediate;
alter pluggable database PDB1 unplug into '/u01/PDB_Archives/PDB1.pdb';
However, if you were to unplug using XML and then use something like 7zip to create the archive you can take advantage of your RDBMS host CPUs to create the archive much, much faster. This is true regardless of what type of storage system you have.