T5140 and Oracle exp or imp
Sunday Nov 30, 2008
A co-worker asked for some help on a customer performance issue where a T5140 was giving what the customer thought was very poor performance for an Oracle export using exp.
The solution?
Data Pump which manifests itself are the tools expdb and impdb. In the lab an export of a 4GB table took 2 minutes with expdp compared to 15 minutes with exp.
The command lines options are probably a little simpler with expdb impdb and the multi-threaded nature suits the CMT architecture of the T5140.
In the customers case, the single threaded exp became cpu bound in memcopy and a internal routine called ttcfour.
If you run Oracle 10 or later on a T series system, then Oracle Data Pump is well worth looking at. I have read an article on an Oracle web site which says it is the recommended tools set, but I can't find the link as I type this.
|
|
|
|
Oracle recommend Data Pump in all situations other...
Thanks Ceri, you are more diligent than I was on a...