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

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

How oramon track Oracle performance? -- V$SESSION

    When hit database load problems, I always want to know what the active sessions are doing and waiting. On 10g we can get these information from V$SESSION view, on 8i and 9i, we can join V$SESSION and V$SESSION_WAIT....

Posted on December 3, 2007 4:45 PM

How oramon track Oracle performance? -- V$SYSSTAT

    Oracle's system level statistics is very useful for performance track. Oracle keep on add new statistics from Oracle 8, 8i, 9i, 10g to 11g. The key is how to display the statistics value. SQL> SELECT name, value FROM...

Posted on November 27, 2007 8:23 PM

Track Oracle database performance with oramon utility

    I am writing an Oracle performance tracking utility -- oramon. And I have finished the first version of it, to make it more powerful, I compiled a windows version binary for free download. What this utility do is...

Posted on October 15, 2007 10:50 PM