RE: Statspack archiving

2002-08-12 Thread Robertson Lee - lerobe
Just a quick note to thank everyone for the contributions to this and the ODBC stuff I posted recently. Regards Lee -Original Message- Sent: 10 August 2002 20:53 To: Multiple recipients of list ORACLE-L The original question on this thread was for an automated "purge" for STATSPACK.

Re: Statspack archiving

2002-08-10 Thread Tim Gorman
The original question on this thread was for an automated "purge" for STATSPACK. I wrote this stored procedure based on the v8.1.7 version of the standard "sppurge.sql" script. I'd use that script, except I don't like the way it is called (i.e. range of SNAP_IDs). This stored procedure figures