T5140 and Oracle exp or imp

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.

Comments:

Oracle recommend Data Pump in all situations other than a) you want to import a file created with exp or b) you might want to import an export file with imp. See http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/exp_imp.htm#g1070082

Posted by Ceri Davies on November 30, 2008 at 02:55 PM GMT #

Thanks Ceri, you are more diligent than I was on a Sunday evening.

Posted by guest on December 01, 2008 at 12:20 AM GMT #

Post a Comment:
Comments are closed for this entry.
About

clive

Search

Categories
Archives
« April 2014
MonTueWedThuFriSatSun
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
    
       
Today