Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Help:how do you clean up perfstat.stats$snapshot?

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

From: Mike F <u518615722_at_spawnkill.ip-mobilphone.net>
Date: Thu, 31 Jan 2002 16:10:41 GMT
Message-ID: <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 Thu Jan 31 2002 - 10:10:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US