Re: Help:how do you clean up perfstat.stats$snapshot?

From: Hemant K Chitale <hkchital_nospam_at_singnet_nospam.com.sg>
Date: Fri, 1 Feb 2002 23:03:18 +0800
Message-ID: <a3ecoi$h3g$1@violet.singnet.com.sg>

Why not use the sppurge.sql script (in $ORACLE_HOME/rdbms/admin) ?

Hemant K Chitale
http://hkchital.tripod.com
"Mike F" <u518615722_at_spawnkill.ip-mobilphone.net> wrote in message news:l.1012493442.1589385986@[64.94.198.252]...
> I created a trigger as follows:
>
> create or replace trigger perfstatonstatup
> after startup on database
> begin
> delete from perfstat.stats$snapshot where snap_id <= (select max
> (snap_id) from perfstat.stats$snapshot);
> commit;
> end perfstatonstatup;
>
> It just take too long in the process. When I try to truncate the table
> perfstat.stats$snapshot, I have to disable all the foreign constaint
> and then re-enable them, and have to truncate each table one by one.
>
> Is there any better way to deal with it?
>
> Thanks
>
>
>
>
>
>
> --
> Sent by dbadba62 from hotmail part of com
> This is a spam protected message. Please answer with reference header.
> Posted via http://www.usenet-replayer.com/cgi/content/new
Received on Fri Feb 01 2002 - 09:03:18 CST