Home » RDBMS Server » Server Administration » Re: Statspack
Re: Statspack [message #369217] Tue, 20 June 2000 14:43
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi,

Unfortunately Oracle does not provide a way to delete individual snapshots. You can easily write such a script yourself. Just find a list of all the STAT$% tables and do the following for each of them:

DELETE FROM stats$librarycache where snap_id = &&snap_id;

Hope it helps.

Cheers
Frank Naude
Previous Topic: Oracle 8 rowid
Next Topic: Re: Difference between Oracle 8.x and 8i
Goto Forum:
  


Current Time: Thu Mar 28 09:19:14 CDT 2024