DBA Tools

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

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

SQLULDR2, upgrade of ociuldr, free of charge now.

    Lot's of DBAs may know the ociuldr utility, to extract rows from Oracle to text file. Now I rewrite ociuldr with OCI 8, and rename it to SQLULDR2 with better performance (almost double) and some good new features,...

Posted on May 5, 2009 7:04 PM

Demo of oramon and WebChart performance solution

    It's quite easy to display database data with WebChart utility. After loading the oramon performance data into database, I create a sample WebChart page to show the performance data, following is the CPU utilization chart.     We...

Posted on April 22, 2009 4:28 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