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 -> Delete with Huge table

Delete with Huge table

From: Eric DUCHET <eric.duchet_at_free.fr>
Date: Thu, 25 Nov 1999 13:20:02 GMT
Message-ID: <6Ia%3.1812$N45.9344122@nnrp1.proxad.net> 





Hi,



I want to know if Oracle works fine for deleting part of huge table (about
50 000 000 rows).


My system is AIX 4.2


Oracle v7.3.4


No archive log.



My performance on my system for deleting 1 000 000 rows is very bad.
How can I improve that ?



(I already have dropped all my indexes)



Can I lauch a parallel query ?



Thanx a lot.






Received on Thu Nov 25 1999 - 07:20:02 CST












Original text of this message













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