DBA Tools

    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, I found that the performance is greatly improved, about 25% improve.

    In my test case, I unload 70 millions rows (about 15GB text file), compare to the old version of ociuldr, the average rows per second improved by 25% or above. The difference between old and new versions is follwoing.

    How I tune the IO function? Just check the source code. You can use ociuldr to take history data backup now, or as a replacement of exp/imp utilities, because sqlldr has a direct load mode, which is much faster than imp utility.

    Enjoy the high speed!