DBA Tools

    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 it to our production databases. The most important thing of new version is that we can load more performance data into performance database, and we can show it easily with WebChart. Here is a few charts from the data gathered by the new version.

    The CPU utilization, including SYS, WIO, USER percent value, and display the data of all the core database hosts into one page for comparation.

    The total wait count of db file sequential read and db file scatter read event, and display the data of all the core database hosts into one page for comparation.

    The total wait time of db file sequential read and db file scatter read event, and display the data of all the core database hosts into one page for comparation.

    The total wait count of db file parallel write and log file parallel write event, and display the data of all the core database hosts into one page for comparation.

    The total wait time of db file parallel write and log file parallel write event, and display the data of all the core database hosts into one page for comparation.

    The average wait time of db file sequential read event, an important measure of the IO response time of the storage, and display the data of all the core database hosts into one page for comparation.

    The total wait count of database read and write wait event, include dba file sequential read, db file scatter read, db file parallel write and log file parallel write event, we get an IOPS from Oracle database layer, and display the data of all the core database hosts into one page for comparation.

    Oramon gathered more data than the above, will draw more charts for better performance analyze.