Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Help:how do you clean up perfstat.stats$snapshot?
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/newReceived on Thu Jan 31 2002 - 10:10:41 CST
![]() |
![]() |