Sunday Nov 30, 2008

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.

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