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

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.

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

Current Time: Sun May 26 10:00:49 CDT 2024