DBA Tools

AnySQL for Micrsoft SQL Server and Sybase

    As an Oracle DBA, I feel no good command line tools when facing SQL Server or Sybase database, not comfirtable with osql or sqlcmd because too much differences with SQL*Plus. AnySQL is Java & JDBC based, it can...

Posted on January 18, 2008 11:16 AM

Describe tables with indexes structure information

    When describe a talbe to get the structure information, I also hope to display the indexes information. In AnySQL, I wrote the DESCRIBE command with this feature. It really save me a lot of time to write SQLs...

Posted on December 20, 2007 10:09 PM

What AnySQL learned from MySQL?

    When I start to learn MySQL database, I feel Oracle SQL*Plus should learn from MySQL to display the result as form style. It's not implemented in Oracle 11g's SQL*Plus, but you are still lucky because I implement it...

Posted on December 20, 2007 10:00 PM

Download AnySQL at file.io file sharing service.

    Just found a file sharing service named file.io, and then decide to upload some of my tools to anysql folder for sharing. You can download AnySQL utility (Search ...) here.     anysql-jre.zip, AnySQL with JRE for Windows,...

Posted on December 20, 2007 9:48 PM

Who is the table lock owner / holder?

    When adding column in out system, I always get resource busy (ORA-00054) errors. If I cannot add it after a lot of retries (we have script to do this). I will try to find out the lock owner,...

Posted on December 17, 2007 10:25 PM

How AnySQL connect to Oracle database?

    AnySQL is a command line database interface tools wrote in Java, just like Oracle's SQL*Plus, but connect to the database via JDBC. There are 3 connect methods available.     The default method is Oracle JDBC Thin driver,...

Posted on December 13, 2007 10:11 AM

Oracle SQL*Plus need learn from MySQL also.

    Oracle 11g learn server result cache from MySQL's query cache, and extend it to client side result cache, this is really cool. But the SQL*Plus also need to run some thing from MySQL, I did learn from MySQL...

Posted on September 9, 2007 12:22 PM