DBA Tools

Performance test of Oracle datapump, exp and SQLULDR2.

    I did a performance comparation of Oracle datapump, export and SQLULDR2 on a linux machine, the CPUs' frequency is 3G HZ. When running exp and SQLULDR2, the relative process take almost 100% of one CPU, so for data...

Posted on April 10, 2009 10:21 AM

SQLULDR2, how to unload data to screen (STDOUT)?

    What's STDOUT, it's the standard output device for a computer, usually it meas the screen. Somebody suggested me to add this feature to ociuldr few months ago, but I did not understand the requirements at that time. Now...

Posted on April 1, 2009 9:46 PM

Specify table name for SQLULDR2 (SQL*Unloader) text unloading

    SQLULDR2 can run as fast as Oracle exp utility with default command line options. If you increase the buffer to 1 megabyte for exp, it's still 15% faster than SQLULDR2. And may be much faster in direct mode...

Posted on April 1, 2009 4:10 PM

sqluldr2 (OCI 8 based) is comming with one megabyte LOB support

    One of my friends need to unload CLOB values to flat file, he tried OCI 7 based ociuldr and sqluldr, both failed. For LOB columns, OCI 7 does have some prolems, it reports "ORA-32255" errors when retrieving NULL...

Posted on March 29, 2009 8:09 PM

The parfile option of newer text unload utility (sqluldr)

    There are lots of command line options for squldr utility, it's not convenient for us to specify lots options value in command line, so I intorduced a new command line option "parfile" to save options value in a...

Posted on March 25, 2009 8:25 AM

sqluldr, enterprise edition text unloading utility

    Ociuldr is a good utility for text unloading, and many people are running it, to avoid compatibilities. I named the new version of text unloading utility as SQL*UnLoader (sqluldr), new version is 25% faster than the old version....

Posted on March 24, 2009 7:34 PM

Text Export and Import Performance Testing

    Since ociuldr get 25% speed improve, I want to know the performance difference with oracle export utility. I tested them on my notebook, oracle server and client in the same host, 8 columns (including VARCHAR, NUMBER and DATE...

Posted on March 23, 2009 5:28 PM

25%+ performance improve for text unloading with ociuldr

    I compared the unload speed of ociuldr and exp utilities, it seemd that ociuldr just has 50% speed compare to exp conventional mehtod, and had no idea of tuning it. After I introduced a buffer layer into it,...

Posted on March 19, 2009 9:35 PM

Export data to fixed length text file with ociuldr

    Sqlldr is much faster for fixed legnth text file, so someone suggest me to add this feature in ociuldr utiltiy, now it supported. When you use a space char as the field separator, it will generate fixed-length text...

Posted on February 17, 2009 7:40 PM

Fast Oracle text unload speed with ociuldr by Alibaba

    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...

Posted on November 29, 2007 8:00 PM