DBA Tools

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

Send oracle performance alert based on oramon performance data

    For critical online transaction process database, it's very important to find out an effective way to monitor the database performance and alert the database performance problem. Because their are many concurrent sessions, any small problem can make the...

Posted on May 23, 2009 9:07 AM

How to keep given gigabytes of archive log files with Perl

    When managing a lot of databases, finding a good policy to manage the archive log files is very important to make the work easy. Usually archive log files are placed on dedicate volumns, purge by space will help...

Posted on November 26, 2008 7:57 PM

Find archive log file by given sequence with perl

    I am writing some DBA scripts with perl, one of them is the archive log file related. I have to implement this feature for more works. The first version is implemented by UNIX find command. # # Get...

Posted on November 26, 2008 7:47 PM

How Perl or asyncdata connect to different databases

    Perl is very popular programming language for DBA scripts and tools, following are the code of how to connect to different database with DBI. There is something special for the DBD-Sybase driver. DBI->connect('DBI:Oracle:tnsname', $user, $pass); DBI->connect('DBI:mysql:database=;host=;port=', $user, $pass);...

Posted on September 14, 2007 2:20 PM

Install ActivePerl, DBI, DBD on Windows for DBA tools

    There are lots of database (including Oracle, Sybase, and all the SQL Servers etc) running on Windows platform, and there are a lots of DBA tools wrote in Perl language. To use them on Windows, you need to...

Posted on September 12, 2007 9:40 AM