OSPRep 0.4.4

Oracle StatsPack Reporter

  Add it to your Download Basket!

 Add it to your Watch List!


Rate it!

What's new in OSPRep 0.4.4:

  • support for 11gR2 (untested)
  • some minor adjustments and improvements
  • some code formatting, including check for (missing) BINDs to be improved
  • added Top-N SQL Statements sections for "..by CPU usage", "..by time elapsed", and "..by Invalidations" (10g+)
Read full changelog
send us
an update
GPL (GNU General Public License) 
ROOT \ Database \ Database APIs
OSPRep is a tool for generating dynamic reports based on statistics gathered by Oracle StatsPack in your database.

OSPRep is an Oracle StatsPack Report Generator, used to generate reports about your database activity statistics in a nice, human readable format - which in this case is HTML -, based on the data collected by Oracle StatsPack and, optionally, some PlugIns shipped with OSPRep. The generated report provides you with information on the physical database design (tablespaces, datafiles, memory), statistical values on your databases efficiency and more. It is highly configurable not only concerning the report elements you need. Due to its modular design, only the needed code (depending on the options you chose in the config file) will be build and executed, to save your database from unnecessary load.

What does OSPRep do?

OSPRep reads its data out of the (level 5 - 7) statistics gathered by the statspack.snap() procedure of Oracle StatsPack and the corresponding procedures from above mentioned plugins. Analogue to the ASCII report one may generate using Oracle StatsPack's spreport.sql, OSPrep generates HTML reports out of these data. The additional information gathered (and reported) by the mentioned PlugIns includes e.g. datafile growth and wait events.

Together with these data, OSPRep gives some descriptions on their meaning as well as ideas what they may point to or what actions are required from the DBA in order to bring the instance to a more efficient state. For some issues, even code pieces for possible required actions are given.

Other useful things to mention here are the AddOns like fts_plans.sh script provided by OSPrep, which can be used to gather execution plans for all SQL statements executed during a certain period of time, having caused full table scans (FTS) - and the charts.sh script, generating some simple charts for selected statistics. This way OSPRep gives you the information on your finger tips to start the tuning of your applications.

What does OSPRep NOT do?

OSPRep will take no (write) actions to the database (only things that OSPRep writes are the HTML report pages and some temporary files; the latter ones are automatically removed when the script finishes). It only does report what it finds in the database plus some general description on those values. It gives no "perfect solution" to problems that may exist with your instance, just hints to what may be helpful. It will not repair or tune your database for you: in order to have this done, you must draw your own conclusions out of the report results.

Last updated on April 22nd, 2011

#Oracle StatsPack #report generator #database statistics #Oracle #StatsPack #database #statistics

Add your review!