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

Home -> Community -> Usenet -> c.d.o.misc -> Re: need to delete 37000000 rows

Re: need to delete 37000000 rows

From: Basil Jackson <BJackson_at_BOSGmbH.Com>
Date: 31 Oct 2001 03:43:23 -0800
Message-ID: <adec38b6.0110310343.46b4a57e@posting.google.com> 





I don't want to be picky, but...



At 800 records per second, it should only take less than 13 hours to
delete 37 million records.  Or have I misunderstood something?



37000000 (records) / 800 (per second) = 46250 seconds
46250 / 3600 (secs per hour) = 12.8 hours.
Received on Wed Oct 31 2001 - 05:43:23 CST












Original text of this message













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