DBA Tools

Oracle Data Recovery Tools

    AUL/MyDUL is an alternative of Oracle DUL, which can read rows directly from data file without Oracle instance. If you cannot start the Oracle database and have no valid backup to restore, you can choose AUL (Feature Overview) as the final solution with much lower cost compare to Oracle DUL service. It has recovered more than 1TB data and more than 20 customers globally.

    You can download and test it (Step by Step) with demo license before you choose it. You can recover the data from a truncated table or database lossing system.

    Anyway, if you have problems when your Oracle database recovery, please contact me by MSN (anysql©live.com) or Skype (anysql).

Oracle Text Unload Tools

    Pure text file is an important way of data exchange, however Oracle does not provide it for us, we have to write our own, ociuldr is one of them wroten in high performance OCI interface. It's free (Download) and you can get the source code to compile it on any OS platform.

    It has a lot of command line options to tune the unload job, and generate the sqlldr control file for data loading & migration. With detailed exit code, you can embed it in your script well.

    Download the detailed document and start to use it!

Oracle Performance Monitor Tools

    Many people don't know how to do performance tuning, just because they don't know where is the problem. So we need an Oracle tool to record some performance data of the database, oramon is one of it. It get performance data from "V$SYSSTAT", "V$SESSION" etc, by comparing the same data (consistent gets, physical read, active sessions etc) of different time, you can easily get to know where is the problem.

    You can download and try it freely if you have no idea of performance tuning, I provide support service of it unfreely, by giving me the data gathered and making suggestions after analyzing the data.

Other Database Tools

    AnySQL is

    asyncdata is

    Compare Any Column is

    ocidiff is

    lobs is

    dmp2utf8 is

Recent 10 posts of this blog

• Recover the table's index structure information.  -  Mar 20, 2008
• Recover the Oracle stored procedures' source code.  -  Mar 20, 2008
• AnySQL for Micrsoft SQL Server and Sybase  -  Jan 18, 2008
• Linux Kernel Parmaters for Oracle 10g RAC  -  Jan 9, 2008
• Mini VMWare Oracle RAC (3GB) on RedHat Linux  -  Jan 2, 2008
• Install the basic Linux X-Window for xterm  -  Dec 31, 2007
• Get Oracle DDL Script  -  Dec 24, 2007
• Get Oracle space usage information in AnySQL  -  Dec 24, 2007
• Drop 4TB table on dictionary managed tablespace  -  Dec 22, 2007
• Describe tables with indexes structure information  -  Dec 20, 2007