DBA Tools

Protect the database connection information in SQLULDR2

    Some departments need to extract rows from the production daily for busines analyze, so we decide to open the standby in read only mode for data extracting with database link. The database link can protect the database user...

Posted on June 11, 2009 8:58 PM

How to change SQLULDR2 session level's parameters?

    Somebody need to change the date type format (default, "yyyy-mm-dd hh24:mi:ss"), and change the numeric characters. For Oracle, you can run some "alter session set ..." commands to make the changes, so I add a new command line...

Posted on June 3, 2009 4:20 PM

Get more than expected from oramon performance alert.

    Now, we have more performance alert point than previously, we just had performance alert based on the load average and active sessions. I were wondering that we will receive too much performance alert and it may bother our...

Posted on May 26, 2009 1:49 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

Deploy the new oramon version to production database hosts.

    I was changing the code of oramon in recent few weeks, keeping on adding more useful performance data and removing useless performance data, it took me one month to finally release the new version of oramon, and deploy...

Posted on May 21, 2009 7:50 AM

SQLULDR2 can compress the output file in GZIP format

    Data compress can save a lot of storage for data archiving, GZIP is a good choise between the compress ratio and compress speed, many utilities support GZIP feature, such as rsync with "-z" option. I spent some days...

Posted on April 17, 2009 4:37 PM

Load oramon performance data into database for further analyze

    The "ANYSQL_OMON_RAW.log" of oramon generated files recorded some performance data for chart type display, but we need to load them into database first. You should create a table with the following structure. CREATE TABLE DATABASE_PERF_STATISTICS (   SID ...

Posted on April 17, 2009 4:24 PM

Install and start oramon to gather performance data

    oramon contains just one executable binary, no installation is required, just download and extract it. Usually we run this utility on database server side, so it can get the database server's OS load information, which can help you...

Posted on April 16, 2009 11:31 AM

Gather and keep Oracle performance data with oramon

    As a DBA, sometime we will get high load alert, usually a sudden load spike. After you take several minutes to login to the system, you will see that the load is quiet, when you want to find...

Posted on April 16, 2009 10:41 AM

A light way Oracle performance tracking solution

    Some DBAs set some alert value for Oracle performance tracking, but that's not enough. For database (not only Oracle) performance, we need gather the performance data, display and analyze the data. DBAs are the critical resource for database...

Posted on April 6, 2009 10:27 PM