DBA Tools

Define the row filters for reports in WebChart

    Supposed that we are creating a report of the top 3 highest salary employees for every department (check the Oracle demo table : SCOTT.EMP). If the table is stored in Oracle database, we could generate the report with...

Posted on March 4, 2010 10:42 PM

Define different SQLs for different databases in WebChart

    Some people like to run WebChart demo application on Oracle database, while some other people may like to run WebChart demo application on MySQL database. Seems I have to write two WebChart demo applications, one for Oracle, another...

Posted on March 3, 2010 5:01 PM

The logical database layer and physical database layer

    Usually our application are bound to one physical database, for example, we always read our data from specific Oracle database or MySQL database, or write business data to specific Oracle database or MySQL database. The physical database is...

Posted on January 27, 2010 6:14 PM

Change the WebChart XSL template to show nagivation links

    After define HTML links for each columns, we need to change the old XSL template to show links in the pages. We can use "href" HTML tag to show it, change the XSL template file as following. <xsl:choose>...

Posted on June 5, 2009 8:59 AM

Create the HREF links in WebChart Pages

    HTML links are very useful for navigation, when we display some summary data in WebChart, we also want to display a href link to display the detail data of relative quater. QUATER COUNT 2008Q1 7363835 2008Q2 9146220 2008Q3...

Posted on June 2, 2009 11:57 PM

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

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

Specify multiple lines value in WebChart defination

    WebChart plays more and more important role in my team, now all of the production DBAs are able to create pages on it. And they gave some good suggestions to make it better. It's easier to specify multiple...

Posted on April 22, 2009 3:47 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