Home » RDBMS Server » Server Administration » Re: Statspack
Re: Statspack [message #369217] Tue, 20 June 2000 14:43
Frank Naude
Messages: 4596
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 04 01:34:10 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.