V2 Installs on Windows or Unix on Standard Edition
The scripts below are brand newer so there will probably be some hickups in them. Please comment on the blog on any issues and/or solutions you find. I wrote these scripts as both an option for installing on Windows (since the first version was a shell script) and for allowing Standard Edition as a repostitory but still having data purging using “poor man’s partitioning”, ie having separte tables for each day of the week, and using view with union all of the 7 tables in the data mining scripts. I find the following scripts easier to follow, read, understand and change than the single script above.
Target – ie Monitored Database , run sys (possible to run as SYSTEM but have to change script not to use x$)
Repository – optional, if you want automatic purging