History for OraRep

Last modified: October 08 2007

v0.3.5 (08.10.2007)

connecting a 10g DB using a 9i client leads to dbms_output.put_line truncating its output after the 254th character (10g doesn't issue an error message any longer until you reach the limit of 32k chars). Applied a work-around to fix this.

added some more hints to the table stats (adapted from OSPRep)

added Makefile for (un)installation with the make utility. After verifying the WEBROOT (and prefix) setting, you may simply invoke "make install" (resp. "make uninstall") from inside the top-level directory of the unpacked tarball (where the Makefile resides).

v0.3.4 (08.11.2005)

made the DBWR+LGWR stats more compact (to fit on one page). Additional comments/hints have been moved to online help

added "related information" to DBWR stats

added instance efficiency stats (adapted from OSPRep)

added load profile (adapted from OSPRep)

added undo statistics (adapted from OSPRep)

added resource limits (adapted from OSPRep)

v0.3.3 (24.10.2005)

added PGA WorkArea Usage statistics to the PGA Target Advice

moved the table infos from misc block to table block

fixed a possible "division by zero" bug in LGWR stats

PGA Target Advice and Shared Pool Advice sometimes have not been created

added "related information" to LGWR stats

added online help for table stats and moved most of the comments there (so the report gets a bit more compact)

v0.3.2 (21.09.2005)

added LGWR statistics. Switch them on/off with the MK_LGWR parameter in the config file

added DBWR statistics. Switch them on/off with the MK_DBWR parameter in the config file.

added table stats

v0.3.1 (07.01.2005)

script now accepts the command line parameters "-r" to use an alternative report dir and "-o" to use an alternativ output file name

the docu and help files as well as the generated reports are now HTML 4.01 conform

v0.3.0 (30.04.2004)

report was broken again for Oracle < v9 due to use of CASE (introduced with Oracle v9)

some formatting updates (numbers not displayed correctly when value to high)

made the remaining values for warnings/alerts (Go4Colors) configurable

some updates to the (HTML) documentation

some formatting (stylesheet) updates

v0.2.7 (10.02.2004)

in the TS Quotas block we now highlight rows (quotas) with non-existing tablespaces: these emerge when dropping a tablespace where quotas where explicitely given by the "ALTER USER...QUOTA..." command, and the quotas would automatically activated if a tablespace with that name would be created

No more empty TSQuotas table (hopefully)

some blocks have not been closed correctly when an error occured

v0.2.6 (04.02.2004)

"Go4Colors Mode": where we can clearly identify problems (e.g. by ratios), the concerning values are now highlighted with red (alert) or yellow (warning) background color of the table cell

report.sh was broken for Oracle versions <9

some formatting on the help files plus more detailled information on cursor_sharing

write enabled data files that have not AUTOEXTEND ON set and filled more than 85% / 95% are now also highlighted with Go4Colors

v0.2.5 (29.01.2004)

added documentation (HTML)

sometimes the "Wait Objects" table was created empty (Oracle removed the entries between the first check [for the link in the header] and creation of the table). Put a note in instead in these cases ;)

added some more details on the buffer waits, plus the optional buffer waits block

restricted the count of tables with less than 10% free blocks (reported at the very end of the page) to TOP_N_TABLES (new config var)

added enqueue stats

added enqueue type descs plus tuning hints

outsourced long hints/descs to external help files via popup on demand

updated installation instructions in doc/readme.txt

v0.1.7 (03.12.2003)

make use of the much more detailed information on objects causing waits in Oracle 9 Release 2 -- for this, outsourced the block and did some ReOrg

added DB Cache advice (needs "db_cache_advice=ready" in the init.ora to show results), Shared Pool Advice and PGA Target Advice (the latter two only show results with Oracle 9 Release 2 and higher, since the views are not available in earlier versions)

Supressed empty tables which sometimes appeared when no data available for certain stats; the according link on top of the page is also removed in these cases

v0.1.6 (27.11.2003)

added DBLinks w/ check whether active or not

added "buffer busy waits" plus more description

made the disksort stats (in SYSSTAT Info) more precise

made description on migrated rows more precise

updated desc for free buffer waits

separated the config from the script to ease updates

v0.1.5 (18.11.2003)

in "Selected Wait Events", Avg Waited is now more precise (while the system view only tells full seconds, we calculate it now ourselves - it's now reported in milliseconds instead of only full seconds)

many numerical values are now presented in a better readable format

added RPP column for Library Cache stats

v0.1.4 (13.11.2003)

added some more comments

added wait event "enqueue"

optimization: created procedure to retrieve the wait event stats

optimization: created procedure print() as wrapper to dbms_output.put_line()