RE: Message at the start of svrmgrl

From: Koivu, Lisa <lisa.koivu_at_efairfield.com>
Date: Mon, 03 Dec 2001 13:39:16 -0800
Message-ID: <F001.003D3D3F.20011203133327@fatcity.com>

Did you trace the statement?  Send a trace to the list. 

-----Original Message-----

From:   Sunil_Nookala_at_Dell.com [SMTP:Sunil_Nookala_at_Dell.com]
Sent:   Monday, December 03, 2001 4:10 PM
To:     Multiple recipients of list ORACLE-L

Subject:        RE: Message at the start of svrmgrl

Hello all,
 

could someone please tell me why the procedure below (Author:Nick Butcher) takes less than a minute on a table with 50,000 rows and about 21 mins on a table with 235,000 rows??
 

I have created a bigger rollback segment to take care of this, but no improvement. where should i be looking for bottlenecks??
 

CREATE PROCUDURE DUPES_DEL  AS
BEGIN
 
 LOOP
 DELETE from fms_test
 where row_id in(select min(rowid)
   from fms_test
   group by sku_num
   having count (*) >1);
  EXIT WHEN SQL%NOTFOUND
 END LOOP;
  
  COMMIT;

END;
 

appreciate it.
Sunil Nookala
DellCorp.
Austin, TX Received on Mon Dec 03 2001 - 15:39:16 CST