SYSMON - Workload Monitoring For Oracle Databases

As presented at the 1995 OAUG conference, SYSMON is an interval based Oracle database monitoring tool that consists of a database procedure that "snaps" file I/O and database statistic information. Although somewhat similar in idea and layout to the utlbstat/utlestat and Statspack information, the fundamental difference between the Oracle supplied utilities and SYSMON is the emphasis on long term monitoring.  SYSMON is not meant to be a replacement for high impact, real time monitoring tools (e.g. OEM top sessions, Orapub's OSM utilities, or Statspack).  It is meant to be used in conjunction with those types of tools to provide long term workload and capacity planning information. A daily workload activity report is also supplied, and other interval based reports are also supplied that can be used to detail file I/O trends and database usage rates.  

Detailed installation instructions and scripts are provided and many additions have been made so check out the README file supplied.  SYSMON now supports a config file so using it with CVS across multiple nodes is much easier, the awk scripts originally used for OS disk stats have been deleted and OS disk stats processing has been simplified.

New! SYSMON is now part of the Open Source orautil project and is available at SourceForge.net. The latest changes include an updated HTML version and a more YAPP like appearance for the daily summary report. SYSMON also fully supports Oracle9i and 10g databases and now supports segment statistics.

Utility Source: sysmon.zip

Example reports:

SYSMON Daily Summary Report (html)

SYSMON Daily Summary Report (text)

SYSMON Tablespace I/O Report

Sample graphs that can be made with SYSMON report data imported into Microsoft Excel -> click here.