Fast Oracle text unload speed with ociuldr by Alibaba

Links: http://www.dbatools.net/mytools/ociuldr_fast_unload_speed.html

    Free Oracle text unload utility (ociuldr) was used to extract Oracle data from OLTP system and then load them into their OLAP system by alibaba company (Taobao). They get a really fast unload speed these days.

0         rows exported at 2007-11-28 06:00:04
153163818 rows exported at 2007-11-28 06:19:14

    Totally 1140 seconds for 153163818 rows, 134354 rows per second, the table size is 79GB, 69MB per second. This is really a fast record. Due to powerful machine, and well tuned SQL, and well tuned ociuldr parameters.

    Another company (Tencent/QQ), did not get this speed when unloading.

    Update: Alibaba doubled the unload speed by running ociuldr at database server side.

0         rows exported at 2007-11-28 15:43:09
171135273 rows exported at 2007-11-28 15:53:04

    How robust their database host is!

Post a comment

« Previous | Main | Next »

Powered by
Movable Type 3.36