DBA Tools

Windows GUI version of SQLULDR2 and DataCopy released.

    SQLULDR2 is a DBA utility to extract Oracle table's data to flat text file, it's based on OCI with excellent performance. Since most of uses like GUI interface, so I released a GUI version of SQLULDR2, let's call...

Posted on May 13, 2010 9:50 AM

SQLULDR2 Windows Developer SDK Released.

    SQLULDR2 is a fast and flexible Oracle text unload utility, but it did not have a good GUI interface, that's because I am not good at writing Microsoft MFC program to create GUI interface. But many and many...

Posted on April 19, 2010 11:55 PM

DataCopy : Native Parallel Support Now ! Parallel Inside !

    We can write a Perl or shell script to start multiple datacopy process with TabSplit utility, now you don't need to write such a Perl or shell script, I have combined the code of TabSplit and DataCopy, we...

Posted on April 17, 2010 12:21 AM

Parallel execution of SQLULDR2 or DataCopy for huge tables

    If we want to process huge tables (few hunderds of gigabytes), it will take long time for a single SQLULDR2 or DataCopy process, single process can makde single CPU exhausted. To speedup the process, we need maually partitioned...

Posted on April 15, 2010 4:06 PM

Data Migration between different Oracle character set

    Supposed that we have few handerds of data stored in US7ASCII database, and we need to switch the system to an UTF8 database, how could we get the system switched in just few minutes without long period outage...

Posted on April 14, 2010 12:35 PM

DataSync: Data Replication (SCOTT.EMP) between Oracle databases

    I want to introduce a new utility for data replication solution based on materialized view log or user defined triggers, I named it as DataSync, suppose that we want to replicate table (SCOTT.EMP)'s data from DB1 to DB2...

Posted on March 25, 2010 3:52 PM

DataCopy : Oracle data migration utility, faster than exp/imp

    We always use Oracle exp and imp utilities to move data from one oracle database to another, but the Oracle imp utility is really slow, because it does not support direct path load, and we must prepare lot's...

Posted on March 17, 2010 5:45 PM

Copy data between different databases with copydata script

    We start to introduce MySQL and PostgreSQL into our business system, as a replacement of Oracle, to save the license cost. First we need to move some data from Oracle to MySQL or PostgreSQL for performance testing or...

Posted on June 10, 2009 9:32 PM

How to Anayze Oracle Performance Data, Lession Two

    Oracle give use lots of performance views, not only for database only, but also some important data about the applications. As a DBA we should analyze those data, and show the data to others. For example, how to...

Posted on May 10, 2009 10:04 PM

How to Anayze Oracle Performance Data, Lession one

    Oracle give use lots of performance views, not only for database only, but also some important data about the applications. As a DBA we should analyze those data, and show the data to others. For example, the SQL...

Posted on May 9, 2009 5:53 PM