今天在删除重复数据的时候，数据库特别的慢，CPU和内存消耗还不是很多。 SQL> delete from test t where (t.doc,t.vol,t.efile)in (select doc,vol,efile from test group by doc,vol,efile having count(*)>1) and rowid not in(select min(rowid) from test group by doc,vol,efile having count(*)>1); ...