ORASNAP REVISION HISTORY

2008.01.14 (14-JAN-2008)
- Updated discons.sql
- Updated tsquota.sql
- Updated invalid.sql
- Updated dbfiles.sql & dbfiles_v7.sql
- Updated objsys.sql
- Added defpass.sql report
- Replaced '999,999' with '999G999' for NLS_NUMERIC_CHARACTERS support
- Updated navigate.htm & links.htm

2007.06.15 (15-JUN-2007)
- Fix: resolved inline view issues in userhit2.sql, userhit3.sql, userhit4.sql
- Updated "source code" files for userhit2.sql, userhit3.sql, userhit4.sql

2007.06.09 (09-JUN-2007)
- Changed version naming (YYYY.MM.DD)
- Added support for 10g (including snap10.sql and snap10*.sql scripts)
- Updated links.htm & navigate.htm
- Updated readme.txt & changes.txt
- Updated snapwrap.sql
- Removed remaining temporary views (replaced with inline views)
- Removed dropview.sql script
- Removed db, custom and db_files directories (no longer supporting custom scripts & multiple databases)
- Replaced all references of http://www.stewartmc.com/orasnap with http://www.oracle-books.com/orasnap
- Using InnoSetup v5.1.12

3.1.0 (06-JUN-2003)
- Updated minisnap7.sql
- Updated minisnap8.sql
- Updated minisnap9.sql
- Updated sgastat.htm
- Updated redoswitch.htm
- Updated rollback.htm
- Updated runsnap.bat
- Added 'custom' directories for user scripts
- Added open in new frame hyperlink
  Click date (top left) on any report to open in new window
- Updated installer script
  Optional desktop and quicklaunch icons
- Updated uninstall script section to remove Yahoo shortcut
- Using InnoSetup v3.0.6

3.0.0 (06-APR-2002)
- Now supporting Oracle9i
  9i requires the SYS user to connect as sysdba or sysoper
  Example: conn sys/<password> as sysdba
  For the snapwrap script - you must include "as sysdba" when you specify the SID/connect string
- OraSnap Yahoo! Group setup
  http://groups.yahoo.com/group/orasnap
- Updated allinit.sql
- Updated cpinterval.sql
- Updated dbfiles.sql
- Updated dbsnaps.sql
- Updated dbtrigs.sql
- Updated large_objs.sql
- Updated minisnap7.sql
- Updated minisnap8.sql
- Updated minisnap9.sql
- Updated part_inds.sql
- Updated part_inds2.sql
- Updated part_tabs2.sql
- Updated rbsgrowth.sql
- Updated redoinfo.sql
- Updated rollback.sql
- Updated sysevents.sql
- Updated snapwrap.sql
- Updated tpcneighbor.sql
- Updated tsinfo.sql
- Updated userhit3.sql
- Updated tsinfo.sql
- Updated undoc.sql
- Updated navigate.htm file
- Consolidated runsnap7/8.bat in db directory
- Using InnoSetup v2.0.19

2.6.0 (03-NOV-2001)
- Updated minisnap7/8.sql scripts
- Updated noextend.sql
- Updated tsusage.sql
- Updated droptemp.sql
- Removed 9 views (3 temporary views remain)
- Minor bug fixes
- Total Reports=112
- Using InnoSetup v2.0.16

2.5.2 (22-SEP-2001)
- Added dbgrowth.sql report
- Minor bug fixes
- Total Reports=112

2.5.1 (04-AUG-2001)
- Added large_objs.sql report
- Minor bug fixes
- Total Reports=111

2.5.0 (07-JUL-2001)
- Added minisnap.sql reports
- Added snap.sql script
- Added tsinfo_v8 source
- Renamed *_v8 files
- Created *_v7 files
- Updated dbi.sql
- Updated datafileio.sql
- Updated droptemp.sql
- Updated tiloc.sql
- Total Reports=110
- Using InnoSetup v2.0.11

2.4.0 (26-MAY-2001)
- Added tsinfo_v8.sql report
- Added part_tabs.sql report
- Added part_inds.sql report
- Added part_key.sql report
- Added part_tabs2.sql report
- Added part_inds2.sql report
- Updated sga.sql
- Updated curusage.sql
- Updated dbfiles.sql
- Updated pts.sql
- Updated ptsavg.sql
- Updated redocont.sql
- Updated resource2.sql
- Updated resource3.sql
- Updated reservepool.sql
- Updated tpcpending.sql
- Updated userhit2.sql
- Updated userhit3.sql
- Updated userhit4.sql
- Updated userobjs.sql
- Updated userobjs_v8.sql
- Updated source code screens
- Total Reports=108
- Using InnoSetup v2.0.9

2.3.3 (27-JAN-2001)
- Added tpcpending.sql report
- Added tpcneighbor.sql report

2.3.2 (02-JAN-2001)
- Trapping OraSnap output in several reports
- Fixed formatting issues on dbsnaps.sql report
- Changed formatting on redoswitch.sql report
- Changed formatting on redoswitch_v8.sql report
- Using InnoSetup v1.3.25

2.3.1 (14-NOV-2000)
- Fixed issue with missing SQL*Plus shortcut

2.3.0 (15-SEP-2000)
- Added autoext.sql report
- Changed sort order for redoswitch reports
- Added OWNER column to pinned.sql report
- Changed formatting on locks.sql report
- Changed formatting on locksql.sql report
- Using InnoSetup v1.3.16

2.2.1 (04-APR-2000)
- Added shortcuts for Oracle8i client software
- Corrected "show source" errors
- Using InnoSetup v1.3.8

2.2.0 (11-MAR-2000)
- Added sesstime.sql report
- Updated redoswitch.sql and redoswitch_v8.sql
- Minor bug fixes
- Using InnoSetup v1.2.14

2.1.1 (12-FEB-2000)
- Added tiloc.sql report
- Removed largeobj.sql report
- Updated a few notes
- Using InnoSetup v1.2.12

2.1.0 (29-JAN-2000)
- Fixed all references to dbcluster.*
- Created "new_db.sh" for UNIX installations
- Added spacealloc.sql report
- Added largeobj.sql report
- Updated userobjs.sql report
- Updated nopk.sql script (now using temp view)
- Updated droptemp.sql to include new view
- Added runsnap7 and runsnap8 batch files
  Kickoff multiple orasnap reports
  See runsnap#.bat files for more information

2.0.0 (20-JAN-2000)
- Monitor multiple databases
- New "wrapper" SQL*Plus short-cut on install
- Updated notes
- Removed "Shared Pool Quick Check" report
- Renamed dbcluster.* to dbclusters.*
- Using InnoSetup v1.2.6

1.3.0 (22-NOV-1999)
- Added maxexts.sql report
- Added sga.sql report
- Added allinitora.sql report
- Added rbsuser.sql report
- Added options.sql report
- Added useraccess.sql report
- Updated tsusage.sql report
- Updated datafiles.sql report
- Renamed sqlhit.sql to libhit.sql
  Updated libhit.sql
- Removed libmiss.sql because of redundancy
- Added FACE/SIZE font elements to all reports
  Reduced report font size for more viewable information
- Reformatted all "source" pages

1.2.1 (06-NOV-1999)
- Added datatypes.sql report
- Added chained.sql report
- Added redoswitch.sql and redoswitch_v8.sql reports
- Total Report=92
- Updated notes
- Using InnoSetup v1.2.5

1.2.0 (30-OCT-1999)
- Added sub-snap# scripts
  Each category can be rerun independent of snap7/8
  (ie. You can rerun "General Information" with snap#gen, rerun "Tablespace Information" with snap#ts, rerun "Rollback Information" with snap#rbs, etc.)
- Added redoinfo.sql report
- Added tsquota.sql report
- Reordered the navigation frame (left frame)
- Updated notes
- Total Report=89
- Using InnoSetup v1.2.4

1.1.8 (13-OCT-1999)
- Minor tweaks
- Using InnoSetup v1.2.4

1.1.7 (22-SEP-1999)
- Completed "Shared Pool Details" report for v8 database

1.1.6 (02-SEP-1999)
- Changed COLSPAN tag to reflect correct number of columns
   (only visible in Netscape)
- Using InnoSetup v1.12.9

1.1.5 (08-AUG-1999)
- Added NLS_DATE_FORMAT to snap#.sql scripts
- Removed individual script date formatting
- Added hints to locks, locksql, and inconsistent reports
- Added footer.js
- Added dbi_v8.sql report
- Total Report=87
- Using InnoSetup v1.12.8

1.1.4 (10-MAY-1999)
- Added 1 new report
- Total Report=84
- Using InnoSetup 1.12.1

1.1.4 (04-APR-1999)
- Added 1 new report
- Total Report=83
- InnoSetup v1.11f

1.1.2 (29-MAR-1999)
- Added 5 new reports
- Total Report=82
- InnoSetup v1.11d

1.1.1 (23-MAR-1999)
- Divided snapX.sql into individual scripts
- InnoSetup v1.11c

1.1.0 (16-MAR-1999)
- Wrote installation script - thanks to Jordan Russell's Inno Setup
- Added 4 new reports
- Total Report=77
- InnoSetup v1.11c

1.0.3 (11-MAR-1999)
- Finished ALL notes - changes/updates will be ongoing
- Added (#) to order by columns in report header
- Added 4 new reports
- Total Report=73

1.0.2 (07-MAR-1999)
- Finished source code for all scripts

1.0.1 (10-APR-1999)
- Added 5 new reports
- Finished HTML code cleanup
- Working on the notes section
- Added frames layout
- Total Report=69

1.0.0 (09-DEC-1998)
- First "official" release