BC remote Oracle DBA - Call (800) 766-1884  
Oracle Consulting Oracle Training Development

Remote DBA

Remote DBA Plans  

Remote DBA Service

Remote DBA RAC

   
Remote DBA Oracle Home
Remote DBA Oracle Training
Remote DBA SQL Tuning Consulting
Remote DBA Oracle Tuning Consulting
Remote DBA Data Warehouse Consulting
Remote DBA Oracle Project Management
Remote DBA Oracle Security Assessment
Remote DBA Unix Consulting
Burleson Books
Burleson Articles
Burleson Web Courses
Burleson Qualifications
Oracle Links
Remote DBA Oracle Monitoring
Remote DBA Support Benefits
Remote DBA Plans & Prices
Our Automation Strategy
What We Monitor
Oracle Apps Support
Print Our Brochure
Contact Us (e-mail)
Oracle Job Opportunities
Oracle Consulting Prices





   

 

 

 

Remote DBA services

Remote DBA Support

Remote DBA RAC

Remote DBA Reasons

Remote Oracle Tuning

Remote DBA Links

Oracle DBA Support

Oracle DBA Forum

Oracle Disaster

Oracle Training

Oracle Tuning

Oracle Training

 Remote DBA SQL Server

Remote MSSQL Consulting

Oracle DBA Hosting

Oracle License Negotiation

 

 


 

 

 

 

 
 

Web-Based Plotting of STATSPACK Data

Oracle Tips by Burleson Consulting

There are several freeware and shareware tools available on the Internet to perform graphical plotting of STATSPACK data, but we will focus on the most popular tools in this section.

The RRDtool Product

The most popular web graphing tool is the RRDtool product, which was formerly the graphing and logging component of the MRTG product. It is a GPLed free software product written by the famous Swiss computer scientist Tobi Oetiker.

RRD is the acronym for the round robin database. The RRD system is designed to store and display any form of time-series data such as server, network, and STATSPACK metrics. Extracts can be written to load RRD with STATSPACK data from the Oracle database and the data can then be used to generate trend analysis graphs in GIF format.

The RRDtool product can be downloaded from the following web site:

http://ee-staff.ethz.ch/~oetiker/webtools/rrdtool/

RRDtool is very flexible, and is generally used by large Oracle sites to display Oracle, server, and network performance data in web pages. At the simplest level, RRDtool accepts data sets and creates GIF files that can then be embedded into HTML pages. Figure 15-13 shows an example of a GIF file generated by RRDtool.

Figure 15-126: An example GIF file created by RRDtool

Please insert figure 15-13 from 007213378-3

Other Web-Based Graphing Tools

There are dozens of interactive web sites that can be used to generate a plot of STATSPACK data. As a representative sample, let's look at the facility offered at the University of New South Wales in Sidney, Australia. Here is a link to their interactive data plotting Web site:

http://www.phys.unsw.edu.au/3rdyearlab/graphing/graph.html

This web site accepts data points and creates the appropriate graph based upon your inputs. In the following example, we paste in our STATSPACK data for average CPU usage by hour of the day. As shown in Figure 15-14, we choose a Gaussian fit technique that gives a smooth curve for the average CPU usage.

Figure 15-127: An example of an Internet-based plotting utility

Next we see the plot for the data (see Figure 15-15). This is presented as a GIF image (General Interchange Format) within the web page.

Figure 15-128: A web-based plot of average CPU percentage

To capture this GIF file for inclusion in an HTML page or a Microsoft Word document, you can simply right-click the image and save it to a local file on your PC (see Figure 15-16).

Figure 15-129: Capturing a web image to a PC file

To summarize, there are a wealth of graphics tools that can be used to plot STATSPACK data and present it in meaningful formats. Regardless of the method you choose, presenting long-term trends with STATSPACK can provide management with critical strategic planning information.


This is an excerpt from "Oracle9i High Performance tuning with STATSPACK" by Oracle Press.


If you like Oracle tuning, you may enjoy the new book "Oracle Tuning: The Definitive Reference", over 900 pages of BC's favorite tuning tips & scripts. 

You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.


Expert Remote DBA

BC is America's oldest and largest Remote DBA Oracle support provider.  Get real Remote DBA experts, call
BC Remote DBA today.

 

   

 

Remote DBA Service
 

Oracle Tuning Book

 

Advance SQL Tuning Book 

BC Oracle support

Oracle books by Rampant

Oracle monitoring software

 

 

 

 

 

 

BC Remote Oracle Support

Remote DBA

Remote DBA Services

Copyright © 1996 -  2013 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.



Hit Counter