Not really oracle related, but a interesting thing and it’s performance related (which is my nr.1 passion)
Haven’t you been upset that bzip2 takes sooo long? Is CPU intensive but just uses 1 CPU (or core).
The solution is pbzip2 which can use multiple cpu’s
CPU: ntel(R) Core(TM)2 CPU 4400 @ 2.00GHz (cache: 2048 KB)
FIle: (mysql dump)
562M 2008-05-14 21:30 shopprod200805132200.dmp
time bzip2 shopprod200805132200.dmp
time bunzip2 shopprod200805132200.dmp.bz2
time pbzip2 shopprod200805132200.dmp
time pbzip2 -d shopprod200805132200.dmp.bz2
So on my machine compression is about 36% faster. Decompression about 76 % faster.