orapub.com
Home
View Cart
My Account
Help
Training
Register Now!
Schedule
About OraPub Training
Class Pics & Video
Quick Links
Craig's Blog
Technical Papers/Books
Tools / Products
Consulting
Speaker Request
About OraPub
Corporate Giving (for real)
Search OraPub:
Home
>
Tools / Products
>
Forecasting data collection script for Oracle and OS (v1.1 May 11, 2007)
Our Price:
Free
Availability:
Available for download now
Product Code:
DATA_GATHER_V1.1
Features
Features
Note: OraPub is always looking for good data to use for R&D and training. If you would like to donate production system data gathered from this script for this purpose, OraPub will create the forecast model for you, validate, calibrate, and present the results all in an Excel spreadsheet. In the US, this will also include a conference call to discuss the results. If you are interested in this, just email support at orapub.com for details.
This is a simple data collection script written for Linux, but it can easily be modified for other platforms. If you look closely, you’ll discover it not only collects CPU and IO activity, but also a few general Oracle workload statistics. The script creates output files for each collection area: CPU, IO, and Oracle data. Each file is in comma-delimited format, so it can be easily loaded into Oracle or a spreadsheet program for processing and analysis.
How to use this tool in real life is presented in our
Forecasting Oracle Performance
class and also in Mr. Shallahamer's book of the same name.
Browse for more products in the same category as this item:
Tools / Products
Automatic Undo Internals (June-2003)
Free
Modern Performance Myths - Presentation RMOUG/IOUG/Collab'06/OOW'06 (October 2006)
Free
Me? Forecast Performance?
Free
A Study in PCTFree In B*-Tree Indexes (Dec-2002)
Free
RT Comparison/Case Graphs (1g, 16-May-2010)
Free
RT Interactive Graphs (1b,01-Sep-2009)
Free
OraPub System Monitor (OSM) Toolkit (v12y for Ora 7-11g, 08-Feb-2010)
Free
OraPub Load Generator (1c 05-June-2008)
Free