2 ms·
I use xargs -P every weekend to back up my (Oracle) database. It has 510 files that are around 2gb, and the parallel script uses rman to make a datafile copy
by chasil 2y ago
I use xargs -P every weekend to back up my (Oracle) database.
It has 510 files that are around 2gb, and the parallel script uses rman to make a datafile copy on each one, lzip it, then scp it to my backup server.
I have xargs set to run 10 at once. Could I increase to 192? Yes.
- bee_rider 2y agoSo the part that would actually benefit from the 192 cores would just be the lzip, right?
- chasil 2y agoOracle enterprise database actually has a retail license cost of $47,500 per cpu core. On x86, there is a two-for-one license discount. In my setup, I have an nfs automount set up from a 12-core machine to my 8-core database. The rman backup and the scp happen locally, but yes, the lzip runs on the compute server.