OraPub, Inc. - Relevant Oracle Training, Products, and Consulting

Training and Resources

Quick Links

About OraPub Training

Home > Tools >

OraPub System Monitor (OSM) Toolkit (v12n for Ora 7-11g, 07-February-2008)

Our Price: Free

Availability: Available for download now
Product Code: OSM12N

Features

The OraPub System Monitor (OSM) is the tool kit we use when consulting and during our training classes. The OSM is a complete set of performance diagnostic tools based upon response time analysis. It also contains a fantastic historical analysis pack which is much better than Statspack (For example, it collects and reports on operating system stats). The OSM is sqlplus based and non-graphic.
OSM Historical (OSM-H) is two tool kits in one. The first part periodically gathers performance data from Oracle, the application, and the operating system. It is also extremely easy to incorporate your own data gathering script into the main driver program (named "rock"). The second part is reporting. Most of the data that is gathered has an associated reporting tool. When you select a range of data gathering periods to report on, you get one or more line of output for each data gathering period. In statspack you only get one. This allows you to see much, much more.
To install, do the typical "tar xvf osmXX.tar". A new osm directory will be created and all the scripts dumped into either the interactive or the historical directory. There is a readme.txt file to get you started. Installing the tools is very simple.
Probably the best interactive tools are rtsysx.sql, swpctx.sql, objfb.sql, tp.sql, sessinfo.sql, swhistx.sql, ashsqlpcte.sql and some of the ASH reports.
Version 12n contains a new script, oscpux[10].sql, which shows operating system CPU utilization. It's based on v$sostat. Some event categories were also fixed up (minor). A new rtsysx.sql script rtsysx10.sql was added to detail with 10g differences compared to 11g. If you are running 10g or 9i use rtsysx10.sql, for 11g run rtsysx.sql, and for anything less than 9i run rtsysx8.sql.
Version 12m contains a number of miscellaneous updates. Nothing shocking, but I recommend upgrading.
The 12k release does a bunch of new and updated stuff. All wait categories have been aligned and fixed up with Oracle 8, 9, 10, and 11. The main response time report (rtsysx.sql) has been enhanced in a number ways including breaking down service time into parse time and other. There is a new simple response time (used loosely) report (rtc[x].sql) based upon Oracle wait event categories. Most of the scripts have been tested in 11g and appear to be working correctly.
The 12j release fixes up some botched wait event categorization for both pre-10g, 10g, and 11g.
The 12i release updates rtsysx8.sql so it works nicely in an Oracle 8 environment. I also added mkodo_ouch.sql which inserts 10k rows into a table, but commits after each one. It's great for testing!
The 12h release looks to have completely fixed all issues with both the delta (blue line) wait event (swpctx.sql) and response time reports (rtsysx8.sql, rtsysx.sql) for all Oracle 9-10gR1/2 releases. The objfb.sql script is also amazingly faster now thanks to a trickly solution by one our students!
The 12g has a few minor updates, but the rtsysx.sql report has been fixed for 10gR2. In R2, Oracle changed some v$osstat, so rtsysx.sql had to be modified to support R1 and R2. Don't forget, there is an rtsysx8.sql that works for Oracle 8 and Oracle 9.
The 12f updates most of the ASH reports to include a session's serial number where appropriate. Also, the response time report, rtsysx.sql, has a fix in the operating system CPU calculations. That's it.
The 12e release contains a few bug fixes for release 12d. There was a problem with osmprep.sql running the old response time view creation script which caused problems with some of the enhanced reports (namely rtsysx.sql). Simply tar xvf the distribution and re-run osmprep.sql and you'll be all set!
The 12d release is truly a major OSM release. Make sure to re-run osmprep.sql!! Here's what new:
- Includes an entirely new set of active session history (ASH) based reports, which all start with the letters ash. Just run the menu script, osmi.sql to see the list.
- The system level response time report (rtsysx.sql) has essentially been entire re-written to increase the data gathering speed, be more readable, and be more accurate. It also also includes additional sections about Oracle CPU consumption (v$sys_time_model) and OS CPU utilization (v$osstat). If you're Oracle release can't handle the new views, just run rtsysx8.sql (which is the older version). This is a wonderful report!
- There are now reports about OS CPU utilization gathered from Oracle (oscpux.sql) and also Oracle CPU consumption (oracpu.sql)
- Wait event time histogram information reports (swhist[x].sql) allow statements like "90% of the scattered reads over the last 10 minutes where less than 8ms."
- Those crazy response time views I created are almost completely gone now with the exception of rtsess.sql (session level RT profile).
- Even swpctx.sql has been upgraded to run quicker in a heavily loaded system.
- The sessinfo.sql script now shows additional v$session columns like module, client_identifier, and blocking_session.
The 11m release has significant fixes to only the interactive portion of OSM. To ensure the new enhancements take affect, if you are upgrading run osmprep.sql again. The following scripts have significant changes/enhancements; rtsesss.sql (session level response time profile) and rtsysx.sql (system level response time analysis profile). A few other scripts have some minor changes aimed at helping you to understand the tool.
The 11g release has some minor fixes to timechk.sql and a couple of other files.
The 11f release has some general fixes, but nothing substantial (that I can remember).
The 11d release has some very significant upgrades. The 11e upgrade had some minor 11d to 11e changes.
- All time is now gathered from v$sysstat's CPU used by this session so it is NO longer necessary to set the init.ora parameter timed_os_statistics. This affected a number of scripts, which have all been updated.
- You do NOT need to connect as user SYS to install the tools anymore! This required a re-write of some of the tools, but they are better than ever!
- We made a number of performance improvements in scripts that gather data for delta reporting. For example, swpctx.sql and rtsysx.sql.
- The top process script (tp.sql) for pre-10g releases (tp9.sql) has been updated and verified (Oracle changed a stat number in 10g, which caused some confusion).

Browse for more products in the same category as this item:

Tools

	OraPub System Monitor (OSM) Toolkit (v12n for Ora 7-11g, 07-February-2008) Free

About Us

Send Us Feedback